SQL Server 2005 存储过程分页

create table t1
(
 id int,
 s1 int
)

Declare @i int
set @i=1
while(@i<200000)
begin
 insert into t1 values(@i+1,@i)
 set @i=@i+1
end

select t.id,t.s1,t.pos from
(
select *,row_number() over (order by s1 desc) as pos from t1
) as t
where t.pos >= 1 and t.pos <= 10