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.
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.