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.
V0097:
The specification states the following:
-
Subclause 8.4, "<XML exists predicate>": Without Feature X096, "XMLExists", conforming SQL language shall not contain <XML exists predicate>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. See the .exist() method of the xml data type [MSDN-Transact-SQLRef] for equivalent functionality.
This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.