How to convert records in a table to xml format using T-SQL?

sql-server, t-sql, xml

Solution

Use the FOR XML in your query.

E.g: `select * from table1 FOR XML AUTO`

see this --> http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1265579,00.html

Alternatively, you can create your own XML in your t-sql code through cursors or in your application code, the longer way of doing it.

Problem

I've got a simple table and want to store its content into a xml on the harddrive. There should be one root element for the whole table, one element per table row and one child element per table column. What possibilities do I have? Thanks a lot Tomas

Original source