2.1.2.90 F661, Simple tables

V0126:

The specification states the following:

 Subclause 7.13, "<query expression>":
  
 <query primary> ::=
 <simple table>
 | <left paren> <query expression body>
 [ <order by clause> ] [ <fetch first clause> ] <right paren>
  
 <simple table> ::=
 <query specification>
 | <table value constructor>
 | <explicit table>
  
 <explicit table> ::=
 TABLE <table or query name>
  
 ...
  
 Conformance Rules
  
 Without Feature F661, "Simple tables", conforming SQL language shall not contain a <simple table> that immediately contains a <table value constructor> except in an <insert statement>.
  
 Without Feature F661, "Simple tables", conforming SQL language shall not contain an <explicit table>.
  
 Subclause 7.3, "<table value constructor>":
  
 <table value constructor> ::=
 VALUES <row value expression list>
  
 <row value expression list> ::=
 <table row value expression> [ { <comma> <table row value expression> }... ]

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

Transact-SQL does not support this feature.