Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.