Paged Select with SqlServer 2005, finally!
Feb 5th, 2007 by Onyrix 603 Views | 
Email This Post
| 
Print This Post
(3 votes, average: 5 out of 5)
Loading ...
I remember the annoying tricks with SqlServer 2000 to have paged results from a query.
For example, in MySql exists the useful keyword limit … using limit 10,10 extracts 10 records after the 10th.
But the question is, what exists in SqlServer 2005?
Well it is not so easy as in MySql but you can do it like:
Code:
declare @pagesize int;
declare @pageindex int;
-- page size
set @pagesize = 10;
-- page offset where 0 == first page
set @pageindex = 0;
select top(@pagesize) *
from sysobjects
where id not in
(
select top(@pagesize * @pageindex) id
from sysobjects
order by name asc
)
order by name asc;
del.icio.us
Digg
Furl
Reddit
Technorati
Stumbleupon