Denali – TSQL Paging November 15th, 2010

Vinod Kumar

I am slightly late on writing about next version of SQL Server release. But here you go – SQL Server “Denali” CTP1 is available for download from the Microsoft Download Center here. Best part is I got did download and get the instance of SQL Denali side-by-side with SQL 2008 R2 instance. These work just as expected even in the current CTP1.

As soon as I got the instance running was looking for something interesting. And this TSQL enhancement caught my attention. All of us do Paging and we do tons of gimmicks to get this working in our application. Now there is a much more Simplified result-set paging via new ANSI standard OFFSET clause within SQL Server natively.

select * from sys.objects
Order by name
Offset 5 rows
Fetch Next 10 Rows ONLY;

You can see how easy now paging is with SQL Server. I will explore the “Improved generation of numeric identifiers using new SEQUENCE object.” and post a simple sample soon.

So what are you waiting for? Download and post me what you found interesting with SQL Server Denali CTP1 …

Books On-Line: Programmability Enhancements topic here.

Tags: , , , , , , , , , ,

This entry was posted on Monday, November 15th, 2010 at 03:50 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Denali – TSQL Paging”

Leave a Reply