converting sql server 2005 data into xml format

bangdad


How to convert table in database, in microsoft sql server 2005 into xml format

Ashish Basran


If you are trying to get data from SQL in XML format, you can query the table and can use "FOR XML" to get data in XML format.

Monica Frintu

Hello,

You can use XPath queries over annotated XSD schemas(http://msdn2.microsoft.com/en-us/library/ms171802.aspx) to get the data in xml format.

I hope this helps,

Monica Frintu