Anup Shah on WPF and Silverlight (Programming Garden)

IT 's For You!!!

Thursday, December 13, 2012

Converting SQL Server Database to XML format


i. First Open Notepad and write below code till </root>:

<root>
<%begindetail%>
<%insert_data_here%>
<%enddetail%>
</root>

Now Save it as c:\sqlexamples\template.tpl

Next you open SQL Server Query Editor and type:

sp_makewebtask @outputfile = 'c:\myxmlfile.xml',
    @query = 'select * from sysobjects for xml auto',
    @templatefile = 'c:\sqlexamples\template.tpl'

The Result is a XML-File!

Happy Coding! ;)

No comments:

Post a Comment