Share via


2.1.2.102 [ISO/IEC9075-14:2011] X206, XMLQuery: NULL ON EMPTY option

V0137:

The specification states the following:

 Subclause 6.18, "<XML query>":
  
 Without Feature X206, "XMLQuery: NULL ON EMPTY option", conforming SQL language shall not contain an <XML query> that contains an <XML query empty handling option> that specifies NULL ON EMPTY.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.

This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.