How to return XML in SQL Server?

 Posted by Raja on 12/14/2008 | Category: Sql Server Interview questions | Views: 8517

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

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: manikandanpszsl-20650 on: 2/8/2013 | Points: 10
wow... nice question...

Login to post response