Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2686, trackbacks - 64

My Links

Advertisement

News

Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

March 2004 Blog Posts

Efficient and DYNAMIC Server-Side Paging with SQL Server 2000

Here is a completely dynamic version of my paging technique in the form of a stored procedure. Just pass in a short SQL statement, the Order By clause, and the start row and end row you'd like to return in the resultset.

read more...

posted @ Monday, March 22, 2004 10:13 PM | Feedback (88) | Filed Under [ T-SQL Paging Data ]

Powered by:
Powered By Subtext Powered By ASP.NET