Share via


2.1.2.95 [ISO/IEC9075-14:2011] X192, XML(CONTENT(XMLSCHEMA)) type

V0130:

The specification states the following:

 Subclause 6.1, "<data type>":
  
 Without Feature X192, "XML(CONTENT(XMLSCHEMA)) type", conforming SQL language shall not contain an <XML type> whose <primary XML type modifier> is CONTENT and <secondary XML type modifier> specifies XMLSCHEMA.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. Transact-SQL supports the primary xml type modifier of CONTENT, but does not support the secondary xml type modifier of XMLSCHEMA. Transact-SQL requires a schema collection for this data type.

This variation pertains to xml data type functionality in SQL Server.