Home > IT Answers > SQL Server > xml create form sql database
11111122222
5 pts.
 xml create form sql database
SQL Server import/export, XML
i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file

Software/Hardware used:
ASKED: August 7, 2008  5:22 AM
UPDATED: August 7, 2008  1:23 PM
RELATED QUESTIONS
Answer Wiki:
You will want to read up on the FOR XML command in SQL Server. This will take the recordset that you create and turn it into an XML document. <pre>SELECT * FROM YourTable FOR XML AUTO</pre> You can find more information in Books OnLine or in the tip <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1265579,00.html">T-SQL commands vs. XML AUTO in SQL Server</a>.
Last Wiki Answer Submitted:  August 7, 2008  8:08 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.