With the release of SQL Server 2005, XML support just got better and SQL Server 2005 provides powerful
XML query and data modification capabilities over XML data. To start with, I introduce the new XML
features of SQL Server 2005 including the FOR XML clause enhancements, XQuery support, and the
XML data type. Then I go on to discuss the execution of FOR XML queries from within ADO.NET both
synchronously and asynchronously. I also discuss the steps involved in working with typed and
untyped XML data type columns. Finally, I illustrate how to retrieve XSD schemas from a typed column
using ADO.NET and also focus on MARS and OPENXML() functions.
you can learn xml at here