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.
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.