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 3. The xml Data Type

The centerpiece of SQL Server 2008 Extensible Markup Language (XML) development is the xml data type. Introduced in SQL Server 2005, this Large Object (LOB) data type supports storage of both typed and untyped XML documents and XML fragments. Each XML instance can be up to 2.1 GB in size.

In this chapter, I will discuss the xml data type, its many uses, and its built-in methods. I'll discuss how to create xml data type instances, cast xml from and to other data types, use inline Document Type Definitions (DTDs) in your XML, and restrict your xml type content to complete documents or fragments. I will also introduce XML schema collections that allow you to validate your xml instances and the xml data type methods for ...

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