Save data from Sql to XML

[jamie_pattison]

How would i save data that is in a SQL database and then save it as XML?

I've searched around but cant find any relevant information.

Thanks

 

[cjard]

Download it into a datatable then use the datatable.writexml(path) method

 

[MattP]

Another option would be using FOR XML: Constructing XML Using FOR XML