Page 1 of 1

Getting XML data

Posted: Thu 09 Dec 2004 18:23
by Ryan
We have a proc that returns some xml using FOR XML EXPLICIT. When i get this value out of the DB is is in an unreadable format (Binary, Unicode or something else). How can I extract the XML text?

Re: Getting XML data

Posted: Fri 10 Dec 2004 09:40
by Ikar
SDAC represents XML in the same form as obtained from the server. We cannot suggest any method of analysing of received result.