The Art of XSD: SQL Server XML Schema CollectionsКНИГИ » ОС И БД
Название: The Art of XSD: SQL Server XML Schema Collections Автор: Jacob Sebastian Издательство: Simple Talk Publishing Год: 2009 Формат: PDF Страниц: 492 Размер: 13 МБ Язык: English
Today, a lot of applications exchange information in XML format. As such, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. With SQL Server 2005 came the new native XML data type, and with it support for a subset of XSD. SQL Server stores XML schemas as ‘XML Schema Collections’, representing SQL Server objects, such as tables, views or stored procedures. Based on an XSD schema, you can create an XML Schema Collection that can be used to validate an XML data type, variable or column. An XML variable or column that is associated with an XML Schema Collection is known as TYPED XML. SQL Server validates a TYPED XML value against the rules defined in the schema collection. INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.
This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XSD is not required to start with this book, although any experience with XSD will make your learning process easier. This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs, in order to build powerful XML schemas in SQL Server.