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.
V0087:
The specification states the following:
-
Subclause 6.8, "<string value function>": Without Feature X074, "XMLSerialize: BLOB serialization and DOCUMENT option", conforming SQL language shall not contain an <XML binary string serialization> that immediately contains 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 serializing from XML(DOCUMENT) to BLOB (VARBINARY). A byte-order mark will be added.
This variation pertains to XML parser functionality in SQL Server.