sql2000的分页

declare @PageLowerBound int
declare @PageUpperBound int

set @PageLowerBound=(@pageindex-1)*@pagesize  990
set @PageUpperBound=@PageLowerBound+@pagesize  1000

set rowcount @PageUpperBound

SELECT
IDENTITY(int, 1,1) AS id,
UesrId as nid

into #pageindex

from Users
where Users.DepSN LIKE @DepSN+'%'
order by Users.Age desc
 

SELECT
u.Name,
u.DepName
FROM Users u,#pageindex as p
where (u.UserID = p.nid)
and (p.id>@PageLowerBound)
and (p.id<=@PageUpperBound)
order by p.id