Returning XML From SQL Server

This "article" is really more of a quick tip. You can easily return XML from any SQL Server Query by including the words FOR XML AUTO at the end of the query.

For example this SQL statment:

SELECT * from Customer FOR XML AUTO

Would return back XML data. It's simple!

from Abstractvb.com