We can use FOR XML statement at the end of the query to return xml data from the SQL Server.
select * from TAbleName for xml auto
There are three mode of returning XML and they are auto, raw and explicit
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
We can use FOR XML statement at the end of the query to return xml data from the SQL Server.
select * from TAbleName for xml auto
There are three mode of returning XML and they are auto, raw and explicit