XML is getting more widely used both inside and outside SQL Server. Stored procedures and functions that accept XML parameters or generate XML documents are part of almost every database project these days. When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. Using an XSD (XML Schema Definition) Schema, you can validate the structure and content of an XML document. SQL Server introduced XML Schema Collections in SQL Server 2005 and added a number of enhancements in SQL Server 2008.
An XML data type variable or column that is bound to an XML Schema collection is called TYPED XML. When a TYPED XML column or variable is modified, SQL Server will validate perform the validations defined in the SCHEMA Collection and the operation will succeed only if the validation succeeds. In this session we will discuss SQL Server XML Schema collections and see how to create powerful XML Schema Collections to validate XML documents with diverse structure and content.