存储过程的分页

存储过程的分页

create procedure blog_page

@pageSize int,

@pageIndex int,

@pageCount int output

as

begin

declare @totleRecords int

select @totleRecords=count(id) frombolg_content

set @pageCount=ceiling(@totleRecords/(@pagesize+0.0));

with temp as (select row_number() over(order by id)as hang,* from bolg_content)

select * from temp where hang between(@pageIndex-1)*@pageSize+1 and @pageIndex *@pageSize

return @totleRecords

end