declare @DataXML xml
set @DataXML =(SELECT * FROM YourTable FOR XML AUTO, ELEMENTS)
select @DataXML
Sunday, June 1, 2008
Subscribe to:
Post Comments (Atom)
I am an Ex-Sailor from Indian Navy who possesses rich experience in Microsoft SQL Server. I would take this opportunity to pay tribute to all those who serve their country with pride, always keeping “Service before Self”.
No comments:
Post a Comment