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.
V0048:
The [ISO/IEC9075-14:2008] specification states the following:
-
Subclause 6.6, "<XML cast specification>": Without Feature X026, "XMLCast: SQL cast semantics", XT is unconditionally the XML Schema type obtained by applying the General Rules of Subclause 9.5, "Mapping SQL data types to XML Schema data types", with SQLT as SQLTYPE, ENC as ENCODING, and "absent" as NULLS.
Microsoft SQL Server 2008 R2 varies as follows:
Transact-SQL does not support this feature. See the .value() method of the xml data type [MSDN-Transact-SQLRef] for equivalent functionality.
Microsoft SQL Server 2012 varies as follows:
This feature is absent in the international standard [ISO/IEC9075-14:2011].
This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.