分页存储过程

sql server成千上万记录分页
Create PROCEDURE GetRecordByPage
@tblName varchar(255),–表名
@fldName varchar(255),–排序的字段名
@fldStr varchar(1000)=*,–字段列表
@pagesize int=10,–页的大小
@pageIndex int=1,–页序号，第多少页
@order char(4)=ASC–排序方式
AS
declare @sqlstr varchar(8000)
set @sqlstr=select +rtrim(@fldstr) + from + ( select top +str(@pagesize)+ +rtrim(@fldstr)
set @sqlstr=@sqlstr+ from ( +select top +str(@pagesize*@pageindex)+ +rtrim(@fldstr)
set @sqlstr=@sqlstr+ from +rtrim(@tblName) + order by +rtrim(@fldName)+ ASC ) a
set @sqlstr=@sqlstr+order by +rtrim(@fldName)+ desc+ ) b order by +rtrim(@fldName)+ +rtrim(@order)

–print @sqlstr
execute(@sqlstr)
GO

转载于:https://www.cnblogs.com/Gaojier/archive/2010/04/08/2783592.html