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.
V0139:
The specification states the following:
-
Subclause 11.5, "<XML passing mechanism>": Without Feature X221, "XML passing mechanism BY VALUE", conforming SQL language shall not contain an <XML passing mechanism> that is BY VALUE.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. The xml data type cannot be used as a parameter to any scalar, built-in functions other than ISNULL, COALESCE, and DATALENGTH.
This variation pertains to xml data type functionality in SQL Server.