Const
SQL Server grammar facts: TOP and OFFSET … FETCH row caps, no ORDER BY in a CTE or derived table without TOP/OFFSET/FOR XML, no nested WITH, plain WITH for recursion, the OPTION (…) hint clause, FOR JSON / FOR XML, CROSS/OUTER APPLY.
TOP
OFFSET … FETCH
WITH
OPTION (…)
FOR JSON
FOR XML
CROSS/OUTER APPLY
SQL Server grammar facts:
TOPandOFFSET … FETCHrow caps, no ORDER BY in a CTE or derived table without TOP/OFFSET/FOR XML, no nested WITH, plainWITHfor recursion, theOPTION (…)hint clause,FOR JSON/FOR XML,CROSS/OUTER APPLY.