Share via


2.1.2.121 F859, Top-level <fetch first clause> in views

V0157:

The specification states the following:

 Subclause 7.13, "<query expression>":
  
 <query expression> ::=
 [ <with clause> ] <query expression body>
 [ <order by clause> ] [ <fetch first clause> ]
  
 ...
  
 <fetch first clause> ::=
 FETCH FIRST [ <unsigned integer> ] { ROW | ROWS } ONLY
  
 Subclause 11.32, "<view definition>":
  
 Conformance Rules
  
 Without Feature F859, "Top-level <fetch first clause> in views", in conforming SQL language, a <query expression> immediately contained in a <view definition> shall not immediately contain a <fetch first clause>.

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

Transact-SQL does not support this feature.