Home > IT Answers > SQL Server > Saving the results of a SQL Server 2005 table...

Question

Asked: Jul 23 2008 5:08 PM GMT
Asked by: SQL Server Ask the Experts

Saving the results of a SQL Server 2005 table query in a XML file

SQL Server 2005, Query, SQL Query

I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.

Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

+1
Click to Vote:

Last Answered: Jul 23 2008 5:28 PM GMT by Mrdenny

You'll want to use the FOR XML clause when you query the table. Unforunately you can't just give SQL the XSD and have it give you the data. It may take a while to get the hang of the FOR XML clause, but once you do it'll be easy.

Take a look in Books OnLine under "FOR XML clause" for the syntax information of using the FOR XML clause.