Share via


2.1.2.45 [ISO/IEC9075-14:2011] X066, XMLParse: BLOB input and DOCUMENT option

V0080:

The specification states the following:

 Subclause 6.16, "<XML parse>": 
  
 Without Feature X066, "XMLParse: BLOB input and DOCUMENT option", in conforming SQL language, the declared type of the <string value expression> immediately contained in <XML parse> shall not be a binary string type and <XML parse> shall not immediately contain a <document or content> that is DOCUMENT.

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

Transact-SQL does not support this feature. See the CAST and CONVERT functions [MSDN-Transact-SQLRef] for equivalent functionality. The CAST and CONVERT functions support parsing from BLOB (VARBINARY) to XML(DOCUMENT).

This variation pertains to XML parser functionality in SQL Server.