Re: FOR XML, TYPE seems broken with latest 1.0x
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4cv1cRKWQpfd2tMNRnNb-866kiSQfWBJxmYHQ6ggmbB+g@mail.gmail.com> |
On 5 Jul 2016 17:06, "Harris, Sean" <[email protected]> wrote: > > 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 > Which tool are you using for doing the query? Frediano