O'Reilly logo

Pro SQL Server 2008 XML by Michael Coles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required