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>
Try the T-SQL forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=85&SiteID=1
-Jamie
