Create xml file from sql server table

Following code will create xml file from sql server table.

SQL Server Table

XML Output

    >/blogs>
          2601
         
          blah blah blah
          2013-02-18 13:57:00
   
     ....
     ....
     ....
     ....
     ....



Script to convert sql server table to xml file

declare @XmlOutput xml

set @XmlOutput =
(select BlogId, Title, ContentValue, CreationDate from Blogs
FOR XML AUTO, ROOT('MyRoot'), ELEMENTS)

select @XmlOutput