2
Reply

How to return XML from the stored procedure in SQL SERVER?

Ankit Agarwal

Ankit Agarwal

13y
3.4k
0
Reply
    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')