Share via


2.1.2.106 [ISO/IEC9075-14:2011] X231, XML(CONTENT(UNTYPED)) type

V0141:

The specification states the following:

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

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 UNTYPED, which is implied by Transact-SQL.

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