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

Asked 2009-10-14T06:19:00.950

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

sql-server xml t-sql

Edit Report

1 Answer

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.

answered 2009-10-14T06:22:22.703

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

1 Answer

Your Answer