Doing XML with T-SQL

In this article, Rick Dobson gives you a quick and useful intro to using XML templates. As you read it, you may also want to read or re-read Rick's January 2004 article on using the Web Services Toolkit to create Web Services and their clients, Tom Moreau's March 2001 column on feeding XML to stored procedures, and the late Anton Britten's February 2002 article on "getting the XML back in."

http://msdn.microsoft.com/xml/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04g1.asp