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.
XML Schema is the W3C recommendation that defines the structure and constrains the content of XML data. SQL Server ...