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.
V0068:
The specification states the following:
-
Subclause 9.14, "Mapping an SQL schema to an XML document and an XML Schema document": Without Feature X051, "Advanced table mapping: null absent", a conforming application shall not invoke this Subclause of this part of this International Standard with NULLS set to indicate that nulls are mapped to elements that are marked to absent elements. Subclause 9.17, "Mapping an SQL catalog to an XML document and an XML Schema document": Without Feature X051, "Advanced table mapping: null absent", a conforming application shall not invoke this Subclause of this part of this International Standard with NULLS set to indicate that nulls are mapped to elements that are marked to absent elements.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. See the ELEMENTS ABSENT option of the FOR XML clause [MSDN-SSDBEng] for equivalent functionality.
This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.