Exporting data as XML file

To get the data from the database table as an XML file we will use " for xml" clause in sql statement in SQLSERVER.

 

But i am not able to generate the following things in that XML file.

please let me know how to get the following details in XML file using sql statement

< xml version="1.0" encoding="UTF-8" >

- <listOfIDXRefData xmlns=some url here>
 
 


Answer this question

Exporting data as XML file