SQL海量分页存储过程

最新推荐文章于 2025-08-07 14:59:42 发布

booth.chen

最新推荐文章于 2025-08-07 14:59:42 发布

阅读量775

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签：存储 sql xp

本文链接：https://blog.youkuaiyun.com/CHBOS/article/details/5778598

数据库专栏收录该内容

23 篇文章

订阅专栏

Create proc xp_Pager
@tableName varchar(20),
@pageSize int,
@pageIndex int,
@primaryKey varchar(20),
@strWhere varchar(500)
as
declare @sqlStr varchar(2000)
if(@strWhere!='')
begin
set @sqlStr='select top '+cast(@pageSize as varchar(10))
     +' * from '+@tableName
     +' where '+@primaryKey
     +' not in (select top '+cast((@pageSize*(@pageIndex-1)) as varchar(10))+' '+@primaryKey
     +' from '+@tableName
     +' where '+@strWhere+' order by '+@primaryKey

     +') and '+@strWhere+' order by '+@primaryKey
end
else
begin
set @sqlStr='select top '+cast(@pageSize as varchar(10))
     +' * from '+@tableName
     +' where '+@primaryKey
     +' not in (select top '+cast((@pageSize*(@pageIndex-1)) as varchar(10))+' '+@primaryKey
     +' from '+@tableName
     +' order by '+@primaryKey
     +') order by '+@primaryKey
end
exec(@sqlStr)