存储过程|分页
使用这个存储过程可以实现分页的，新手可以看看哦！
create proc proPage(pageid int ,pagesize int)
as
begin
if (pageid=1)
begin
set rowcount pagesize
select * from test order by id
end
else
begin
declare no1 int
declare num int
select num=pagesize*(pageid-1)
set rowcount num
select no1=id from test order by id
declare no2 int
select num=pagesize*pageid
set rowcount num
select no2=id from test order by id
set rowcount 0
select * from test where id>no1 and id<
end
end
