Microsoft SQL Server 2005 & XMLSupport
A very good article on XML Support in Microsoft SQL Server 2005
This article explains the XML support built into SQL Server 2005. It shows how XML integrates with the client side programming of .NET Framework V2.0 and in native code such as OLEDB and SQLXML.
The following topics are covered in this article:
- XML data type
- XML indexing
- XML schema processing
- ForXML and OpenXML enhancements
- Client access to XML data type
- Data modeling
- Methods of XML data type
- XQuery language
- Cross-domain queries
- Content indexing
and much more...
Very interesting one don't miss it..