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.
V0069:
The specification states the following:
-
Subclause 9.14, "Mapping an SQL schema to an XML document and an XML Schema document": Without Feature X052, "Advanced table mapping: null as nil", 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 with xsi:nil="true". Subclause 9.17, "Mapping an SQL catalog to an XML document and an XML Schema document": Without Feature X052, "Advanced table mapping: null as nil", 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 with xsi:nil="true".
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature. See the ELEMENTS XSINIL option of the FOR XML clause [MSDN-SSDBEng] for equivalent functionality.
This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.