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.
V0077:
The specification states the following:
-
Subclause 6.16, "<XML parse>": Without Feature X060, "XMLParse: Character string input and CONTENT option", in conforming SQL language, the declared type of the <string value expression> immediately contained in <XML parse> shall not be a character string type and <XML parse> shall not immediately contain 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. These functions support parsing from string (NVARCHAR) to XML(CONTENT).
This variation pertains to XML parser functionality in SQL Server.