By DotNetBlocks
via simple-talk.com
Published: Nov 20 2012 / 08:18
SQL Server lets you retrieve data as XML by supporting the FOR XML clause, which can be included as part of your query. You can use the FOR XML clause in the main (outer) query as well as in subqueries. The clause supports numerous options that let you define the format of the XML data.
Add your comment