分页存储过程

最简单的分页存储过程：

CREATE proc sp_fixpage @pagesize int,@destpage int  as
set nocount on
declare @id int
declare @startid int

select @startid = (@destpage - 1)*@pagesize

set rowcount @startid
select @id = id from t_member

set rowcount @pagesize
set nocount off
select * from t_member where id > @id order by id

 

存储过程模板：

create proc
@pagesize int,
@pagecurrent int
as
declare @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)