Pro SQL Server 2008 XML

Chapter 4. XML Schema Collections

In this chapter, you will look at designing and implementing XML schema collections, which are used to create typed XML data. An XML schema collection uses the XQuery/XPath Data Model (XDM) to define the structure of, and constrain the values contained by, your typed xml instance objects. I will discuss SQL Server statements for creating and managing XML schema collections, and you will work with XML Schema data types. Throughout this chapter, you will build a sample XML schema collection to create a typed xml instance for a sample recursive Bill of Materials (BOM) in XML format.

Introducing XML Schema

XML Schema is the W3C recommendation that defines the structure and constrains the content of XML data. SQL Server ...