SQL Server Denali CTP1 – Paging support

The new SQL server version codename Denali features better paging support. You can now write code like this: SELECT Field1, Field2 FROM TableX ORDER BY Field1 OFFSET 100 ROWS FETCH NEXT 50 ROWS ONLY  This code will give you the 50 records with starting position 100. Yes, the query has to  be executed one time for each page you are pulling from your code and that can be unefficient.

If you want to know more about SQL server and Denali, feel free to contact our SQL server speciallists.