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.
V0151:
The specification states the following:
-
Subclause 12.1, "<column definition>": Without Feature X257, "Persistent XML values of XML(CONTENT(XMLSCHEMA)) type", conforming SQL language shall not contain a <column definition> whose declared type is based on either the XML(CONTENT(XMLSCHEMA)) type or a distinct type whose source type is the XML(CONTENT(XMLSCHEMA)) type. Subclause 12.4, "<view definition>": Without Feature X257, "Persistent XML values of XML(CONTENT(XMLSCHEMA)) type", conforming SQL language shall not contain a <view definition> that defines a column whose declared type is based on either the XML(CONTENT(XMLSCHEMA)) type or a distinct type whose source type is the XML(CONTENT(XMLSCHEMA)) type.
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. Instead, XML Schema collection names are referred to directly.
This variation pertains to xml data type functionality in SQL Server.