FOR XML, TYPE seems broken with latest 1.0x
"Harris, Sean" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hey guys,
So I updated a mac dev machine to the latest release available via home brew (1.00.9).
After this any queries using the TYPE directive for XML return an unknown type error.
example query: SELECT * FROM users WHERE id = 123 FOR XML PATH('users'), ROOT('xmlObject'), TYPE
About the TYPE directive: https://msdn.microsoft.com/en-us/library/ms190025.aspx