最简单的分页存储过程：
CREATE proc sp_fixpage @pagesize int,@destpage int as set nocount ondeclare @id intdeclare @startid int
select @startid = (@destpage - 1)*@pagesizeset rowcount @startidselect @id = id from t_member
set rowcount @pagesizeset nocount offselect * from t_member where id > @id order by id
存储过程模板：
create proc@pagesize int,@pagecurrent intasdeclare @id1 varchar(20)declare @id2 varchar(20)declare @sql varchar(1000)
select @id1=cast(@pagesize as varchar(20))select @id2=cast(((@pagecurrent-1)*@pagesize) as varchar(20))
select @sql=''
exec(@sql)
