JSP,ASP.NET,sql海量分页存储过程

create proc PageNum
 @PageSize int,           --每页显示条数
 @PageIndex int,          --当前是第几页
 @totalRows int output,   --总行数
 @totalPages int output         --总页数
as
 declare @startId int
 declare @endId int
 set @startId = @PageSize*(@PageIndex-1)+1
 set  @endId = @startId+@PageSize-1
 select @totalRows=COUNT(*) from Books
 set @totalPages=@totalRows/@PageSize
 if(@totalRows%@PageSize != 0)     --如果总行数除每页显示数据量的值不等于0,则总页数得加1
 begin
  set @totalPages=@totalPages+1
 end
 declare @IndexTable table(Id  int identity(1,1) ,nId int)
 insert into @IndexTable select Id from Books
 select * from @IndexTable as t ,Books as b where t.Id>=@startId and t.Id<=@endId and t.nId=b.Id
go
 
declare @tr int --总行数
declare @tp int --总页数
exec PageNum 4,2,@tr output ,@tp output
print  '这是总页数'+convert(varchar,@tp)     --数据转换
print  @tr