Ravi

• Nov 21st, 2007

 

The only thing you have to do is to insert "for XML Auto" in your query and the result will be returned in XML format.

Eg. Let there be a table with name tblABC

Normally
    Select * from tblABC

For XML Data
    Select * from tblABC for XML Auto