How to return XML from the stored procedure in SQL SERVER?
Ankit Agarwal
SELECT * FROM TABLENAME FOR XML AUTO,ELEMENTS which return the XML data with thier individual elements
we can get the xml form of output by this kind of querry in sql server that is FOR XML RAW,ELEMENTS,ROOT('ROORNAME')