sql-How to convert a table data into XML

[dilyskam]

HI ALL,

sql-How to convert a table data into XML.

PLS. HELP!!!!!

[debasisdas]

As you have posted a question in the articlese section it is being moved to SQL Server Forum.

MODERATOR.

[azimmer]

HI ALL,

sql-How to convert a table data into XML.

PLS. HELP!!!!!

It's too lengthy to be described here and anyway: read the OPENXML section in SQL Server's help, it's available online here: http://msdn2.microsoft .com/en-us/library/ms186918.aspx and this one too: http://msdn2.microsoft .com/en-us/library/ms187897.aspx