2 out of 4 rated this helpful - Rate this topic

xml (Transact-SQL)

SQL Server 2012

Is the data type that stores XML data. You can store xml instances in a column, or a variable of xml type.

Topic link icon Transact-SQL Syntax Conventions

xml ( [ CONTENT | DOCUMENT ] xml_schema_collection )

Arguments

CONTENT

Restricts the xml instance to be a well-formed XML fragment. The XML data can contain multiple zero or more elements at the top level. Text nodes are also allowed at the top level.

This is the default behavior.

DOCUMENT

Restricts the xml instance to be a well-formed XML document. The XML data must have one and only one root element. Text nodes are not allowed at the top level.

xml_schema_collection

Is the name of an XML schema collection. To create a typed xml column or variable, you can optionally specify the XML schema collection name. For more information about typed and untyped XML, see Compare Typed XML to Untyped XML.

Remarks

The stored representation of xml data type instances cannot exceed 2 gigabytes (GB) in size.

The CONTENT and DOCUMENT facets apply only to typed XML. For more information see Compare Typed XML to Untyped XML.

Examples

USE AdventureWorks;
GO
DECLARE @y xml (Sales.IndividualSurveySchemaCollection)
SET @y =  (SELECT TOP 1 Demographics FROM Sales.Individual);
SELECT @y;
GO

Reference

Data Types (Transact-SQL)

Concepts

Data Type Conversion (Database Engine)

Other Resources

xml Data Type Methods

XQuery Language Reference (SQL Server)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD