XML From SQL Server

SELECT * FROM customer FOR XML RAW

2.SELECT * FROM customer FOR XML AUTO

3.SELECT * FROM customer FOR XML AUTO, ROOT('customers')

4.SELECT * FROM customer FOR XML AUTO, ELEMENTS, ROOT('customers')

5.SELECT * FROM customer FOR XML AUTO, ELEMENTS XSINIL, ROOT('customers')


http://dotnetslackers.com/articles/xml/Dynamic_XML_From_SQL_Server.aspx