2.1.2.49 F302, INTERSECT table operator

V0085

The specification states the following:

 Subclause 7.13, "<query expression>":
  
 <query expression> ::=
 [ <with clause> ] <query expression body>
 [ <order by clause> ] [ <fetch first clause> ]
  
 ...
  
 <query expression body> ::=
 <query term>
 | <query expression body> UNION [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query term>
 | <query expression body> EXCEPT [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query term>
  
 <query term> ::=
 <query primary>
 | <query term> INTERSECT [ ALL | DISTINCT ]
 [ <corresponding spec> ] <query primary>
  
 ...
  
 Conformance Rules
  
 Without Feature F302, "INTERSECT table operator", conforming SQL language shall not contain a <query term> that contains INTERSECT.

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

Transact-SQL partially supports this feature.