Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Server XML Schemas

By Jacob Sebastian,

SQL Server Development Series

Art of XSDThe Art of XSD: SQL Server XML Schema Collections by Jacob Sebastian
(1st Edition, March 2009)

Download eBook (PDF): Free
Buy Printed Book: $29.99


"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. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. " – Jacob Sebastian


View Related Books:


Editorial Review

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.

If you have any question on the topics discussed in this book or on XSD in general, feel free to write to me at jacob@beyondrelational.com.

About the Author

Jacob Sebastian is co-founder and CTO of Excellence Infonet (http://www.excellenceinfonet.com), Ahmedabad, an Indian unit of a US based software firm. Being the CTO of the company, Jacob contributes as Solution Architect and spends most of his time with SQL Server. Jacob is a Microsoft MVP (SQL Server) and a Moderator at MSDN and Technet Forums. He volunteers for the Professional Association for SQL Server (PASS: http://www.sqlpass.org) as a Chapter Lead. He is a regular columnist at SQLServerCentral ( http://www.sqlservercentral.com) and blogs regularly at http://jacobsebastian.blogspot.com/ on SQL Server and XML related topics. Jacob is Founder and President of Ahmedabad SQL Server User Group, a PASS chapter (http://ahmedabad.sqlpass.org) and works with a number of User groups in India.

Jacob started his database career in the mid nineties with Dbase, Foxbase, Clipper and Foxpro. He then moved to SQL Server 6.0 and worked on a number of applications on VC++/MFC/ATL/COM/VB. When not working, Jacob would like to spend time with family and friends and watch movies; but often gets engaged with helping someone in the SQL Server forums, writing articles, blogs or a book, learning SQL Server or creating a presentation for the next UG meeting.


Book Details

Paperback: 467 pages
Publisher: SQL Server Central Books

Total article views: 4961 | Views in the last 30 days: 11
 
Related Articles
ARTICLE

XML Schema validation in SQL Server

An introduction to the XML Schema Collection and XML validation.

FORUM

Schema validation

Validate schema against remote server

ARTICLE

XML Workshop VII - Validating values with SCHEMA

This installment of the XML Workshop by Jacob Sebastian continues looking at XML Schemas in SQL Serv...

ARTICLE

XML Workshop VI - Typed XML and SCHEMA Collection

The sixth installment of the XML Workshop for SQL Server shows how the XML Schemas fit into the XML ...

FORUM

RaiseError in TRY/Catch block after XML Schema Collection Validation.

I am trying to raiseerror if XML schema validation fails, however not able to.

Tags
books    
development    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones