数据库储存过程万能分页

alter proc usp_GetPageItems1
@page int,
@pagesize int,
@table varchar(20)
as
declare @sql varchar(200)
set @sql='select * from (select *,ROW_NUMBER()
over(order by getdate()) id from '+@table+')tt
where tt.id between '+cast((@page-1)*@pagesize+1 as varchar(50))+'and '+cast((@page*@pagesize) as varchar(50))+''
exec(@sql)

exec usp_GetPageItems1 1,2,cardInfo

转载于:https://www.cnblogs.com/java-Blog/p/6823905.html