Share via


2.1.2.62 [ISO/IEC9075-14:2011] X096, XMLExists

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.