How to return XML in SQL Server?

Answer:

We can use FOR XML statement at the end of the query to return xml data from the SQL Server.

select * from mytable for xml auto

There are three mode of returning XML and they are auto, raw and explicit

For more details see http://www.sqljunkies.ddj.com/Article/296D1B56-8BDD-4236-808F-E62CC1908C4E.scuk