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

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question