Share via


2.1.2.108 [ISO/IEC9075-14:2011] X241, RETURNING CONTENT in XML publishing

V0143:

The specification states the following:

 Subclause 6.11, "<XML comment>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML comment> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.12, "<XML concatenation>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML concatenation> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.13, "<XML document>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML document> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.14, "<XML element>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML element> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.15, "<XML forest>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML forest> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.17, "<XML PI>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML PI> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 6.19, "<XML text>": 
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML text> shall not specify an <XML returning clause> that is RETURNING CONTENT.
  
 Subclause 11.2, "<aggregate function>":
  
 Without Feature X241, "RETURNING CONTENT in XML publishing", in conforming SQL language, an <XML aggregate> shall not specify an <XML returning clause> that is RETURNING CONTENT.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.

This variation pertains to XML 1.0 [XML10/5] functionality in SQL Server.