Tuesday, June 03, 2008

How to assign XML output of select * FROM Yourtable FOR XML AUTO query to a variable

declare @DataXML xml
set @DataXML =(SELECT * FROM YourTable FOR XML AUTO, ELEMENTS)
select @DataXML

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home