XML Data Types in SQL Server 2005
In this tutorial you will learn about XML Data Types, Query and Inexes in SQL Server 2005 - XML Data type, XML Typing, Advantages of storing XML in databases, Untyped XML data, Using Typed XML, Managing XML indexes, XQuery and XQuery syntax.
XML Data type
As stated above the XML data type is a new introduction in SQL Server 2005. It enhances the developer’s ability to work with XML within the framework of T-SQL. This data type can be used just like any other data type, be it a typing of variables or columns. A number of methods have been defined for this data type which enables optimal use of the XQuery to check data existence or individual values. XML Data can be queried or modified.
XML Typing
When schemas are registered in SQL Server 2005 database, it has the added advantage of constraining and typing XML. This reduces storage size and provides a mechanism for validation.
The process of creating typed XML involves the creation of schema collections within the database. This is accomplished using CREATE XML SCHEMA COLLECTION statement. Each schema within the collection describes a namespace.
Read
More...
http://www.exforsys.com/content/view/1735/356/