Page 1 of 1

XML Retreival

Posted: Mon 31 Jan 2005 19:28
by Ryan
When I set my query to return FOR XML AUTO, how can I get the XML out into a string? We are using TMSStoredProc.

Thanks

RYan

Posted: Tue 01 Feb 2005 09:59
by Ikar
SDAC doesn't perform any conversions under retrieved as a result of query data. Try to search for an answer in MSDN

XML

Posted: Wed 02 Feb 2005 17:55
by Ryan
What does "perform any conversions under retrieved" mean?

Posted: Thu 03 Feb 2005 09:32
by Ikar
A result of this query doesn't pass any additional processing. So server returns through OLE DB data in some format and SDAC by Fields[] returns it at the same type without any conversion.