New Features in SQL Server Denali for SQL Developers

Microsoft SQL Team has recently released Microsoft SQL Server Denali CTP 1 for SQL Server administrators and sql developers who wants to evaluate the new SQL Server Denali features.

What is new in SQL Server Denali at first look is the Sequence Objects, Server-Side Paging feature with new OFFSET n ROWS  and FETCH NEXT n ROWS ONLY enhancements  in ORDER BY clause.

There are other improvements in sql programmability in SQL Server Denali but I'm sure the two features will have a common acceptance by the sql developers.

Here is a sample SQL Select statement where you can use for your paging requirements in your applications.

SELECT *
FROM dbo.Employees
ORDER BY LarstName
 OFFSET 10 ROWS
 FETCH NEXT 10 ROWS ONLY

For more explanation with t-sql samples, please refer to SQL tutorial OFFSET n ROWS  FETCH NEXT n ROWS ONLY in ORDER BY Clause for SQL Paging in SQL Server 2011