Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Query to Return the XML formated Output in SQL Server

March 7 2009 , Written by Balavardhan Published on #SQL Server2005

Get the Result in XML format by the Query in SQLServer


SELECT <<Column Name1>>,<<Column Name2>>,<<Column Name3>>... FROM << TABLENAME >>
For XML
PATH ('<<String For Path Node>>'),
ROOT('<<String For Root Node>>')

Share this post

Repost 0

Comment on this post