最简单的分页存储过程:
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)