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.
V0142:
The specification states the following:
-
Subclause 6.1, "<data type>": Without Feature X232, "XML(CONTENT(ANY)) type", conforming SQL language shall not contain an <XML type> whose <primary XML type modifier> is CONTENT and <secondary XML type modifier> is ANY.
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 ANY.
This variation pertains to xml data type functionality in SQL Server.