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
Found interesting? Add this to: