converting sql server 2005 data into xml format

How to convert table in database, in microsoft sql server 2005 into xml format?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.|||

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