SQL Server 2005 XML fun

[Private_Void]

I was playing with SQL the other day and ran across a way to automatically create XML Documents with just T-SQL and Built in funtionality of SQL Server 2005. It goes like this; SELECT * FROM [Table] FOR XML AUTO, ELEMENTS Then you click on the results. A new window opens with your Schema / Data in place. I thought it was cool, and I hope it helps someone.