Share via


2.1.2.73 [ISO/IEC9075-14:2011] X132, XMLBINARY clause in DML

V0108:

The specification states the following:

 Subclause 14.3, "<delete statement: searched>": 
  
 Without Feature X132, "XMLBINARY clause in DML", in conforming SQL language, a <delete statement: searched> shall not immediately contain an <XML lexically scoped options> that contains an <XML binary encoding>.
  
 Subclause 14.4, "<insert statement>": 
  
 Without Feature X132, "XMLBINARY clause in DML", in conforming SQL language, an <insert statement> shall not immediately contain an <XML lexically scoped options> that contains an <XML binary encoding>.
  
 Subclause 14.5, "<merge statement>": 
  
 Without Feature X132, "XMLBINARY clause in DML", in conforming SQL language, a <merge statement> shall not immediately contain an <XML lexically scoped options> that contains an <XML binary encoding>.
  
 Subclause 14.6, "<update statement: positioned>": 
  
 Without Feature X132, "XMLBINARY clause in DML", in conforming SQL language, an <update statement: positioned> shall not immediately contain an <XML lexically scoped options> that contains an <XML binary encoding>.
  
 Subclause 14.7, "<update statement: searched>": 
  
 Without Feature X132, "XMLBINARY clause in DML", in conforming SQL language, an <update statement: searched> shall not immediately contain an <XML lexically scoped options> that contains an <XML binary encoding>.

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.