sql server 預存程序分頁

標籤：

create proc [dbo].[sp_GetPagedList]
(
@pageIndex int,
@pageSize int,
@orderBy nvarchar(512),
@columns varchar(512) ,
@tableName varchar(512),
@where nvarchar(max)
)
AS
begin
declare @sql nvarchar(max)
declare @currPage int
set @[email protected]*@pageSize
set @sql=‘
select count(*) from (
select ROW_NUMBER() over (order by ‘[email protected]+‘ desc) as rowid,‘[email protected]+‘ from ‘[email protected]+‘ where 1=1 ‘+
@where+‘
) temp ‘
 
exec(@sql)
set @sql=‘
select * from (
select ROW_NUMBER() over (order by ‘[email protected]+‘ desc) as rowid,‘[email protected]+‘ from ‘[email protected]+‘ where 1=1 ‘+
@where+‘
) temp where rowid between ‘+Convert(varchar(50),@[email protected]+1)+‘ and ‘+Convert(varchar(50),@currPage)
exec(@sql)
end

sql server 預存程序分頁