--分页存储过程
创建存储过程:
create proc procPaging
(
@tablename nvarchar(100), --表名
@column nvarchar(100)=null, --列名
@sort nvarchar(10), --排序asc,desc)
@pageIndex int, --当前页码
@pageCount int --每页显示多少条数据
)
as
begin
declare @strSql nvarchar(max)
set @strSql='select * from (select ROW_NUMBER() over(order by '+@column+' '+@sort+' ) as rowid,* from '+@tablename+') newtable
where rowid between '+ cast((@pageindex-1)*@pagecount+1 as nvarchar(100))+' and '+convert(varchar(20),@pageIndex*@pageCount)
exec (@strSql) --执行字符串的SQL语句
end
执行存储过程:
exec procPaging 'BookShop_BookType','BookType_ID','asc',1,3
exec procPaging 'BookShop_BookType','BookType_ID','asc',2,3
删除存储过程
drop proc book_Paging