Export Table to Xml using sql

[gnr_gattadi@yahoo.com]

Hi All,

Is there any Query to Export Table to Xml File Using Sql Server?


Plz Suggest Me ...

Thx in Advance

[KrisSimonis]

With MS SQL 2005 you can use the 'FOR XML' statement apended to a query to turn it into XML.

[gnr_gattadi@yahoo.com]

Thank you very much simon,

But my problem is to save the whole table data in an xmlDocument File;

for ex:
Select * from Tablename to "C:\myxml.xml"


I need a sql query to Export table to xml file.

If any suggestions



Thxxxxxxxxxx

[KrisSimonis]

if you're using MS SQL 2005:


SELECT *
FROM Table
FOR XML AUTO


it's that easy.