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
set @DataXML =(SELECT * FROM YourTable FOR XML AUTO, ELEMENTS)
select @DataXML
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home