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.
V0083:
The specification states the following:
-
Subclause 6.8, "<string value function>": Without Feature X070, "XMLSerialize: character string serialization and CONTENT option", conforming SQL language shall not contain an <XML character string serialization> that immediately contains a <document or content> that is CONTENT.
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(CONTENT) to string (either as NVARCHAR or VARCHAR).
This variation pertains to XML parser functionality in SQL Server.