Tuesday 28 April 2015

How to return XML in SQL Server.?

How to return XML in SQL Server.?


We can use FOR XML statement at the end of the query to return XML data from the SQL Server.
select * from table_name FOR XML auto

There are three modes of returning xml  and they are auto, raw and explicit.

No comments:

Post a Comment