sqlserver·ÖÒ³´æ´¢¹ý³ÌµÄÓ÷¨

create proc P_QuerySplit
 @sqlscript varchar(20),         --±íÃû/SQLÓï¾ä
 @pageSize int,                  --ÿҳ¼Ç¼Êý
 @pageIndex int,                 --µ±Ç°Ò³
 @totalCount int output,         --×ܼǼÊý
 @totalPage int output        --×ÜÒ³Êý
as
  declare @v_sqlscript varchar(20)
  declare @v_PageSize int
  declare @v_PageIndex int
  declare @v_SQL_Count int
  declare @v_SQL varchar(4000)
  declare @v_StartIndex int
  declare @v_EndIndex int
 set @v_PageSize=@pageSize
 --ÿҳ¼Ç¼Êý
if @v_PageSize=0
 set @v_PageSize=1
print @v_pageSize
--²éѯ×ܼǼÊý
select @v_SQL_Count=count(1) from stuInfo
set @totalCount=@v_SQL_Count
print @totalCount
--×ÜÒ³Êý
set @totalPage=ceiling(@totalCount/@v_PageSize)
--µ±Ç°Ò³
if(@pageIndex=1 or @pageIndex<1)
begin
 set @pageIndex=1
 set @v_PageIndex=@pageIndex
 set @v_StartIndex=0
 set @v_EndIndex=ceiling(@v_pageIndex*@v_pageSize)
print    @pageIndex
 
end
if @pageIndex>1
begin
 set @v_PageIndex=@pageIndex
 set @v_StartIndex=ceiling((@v_PageIndex-1)*@v_PageSize)
 set @v_EndIndex=ceiling(@v_pageIndex*@v_pageSize)
print  @pageIndex
 
end
 
 
set @v_sqlscript=@sqlscript
--µ±Ç°Ò³µÄ¼Ç¼
--  set @v_SQL='select top'+str(@v_PageSize)+' * from '+ @v_sqlscript+
--' where (id>(select max(id) from (select top '+str(@v_startIndex)+' id
--from '+ @v_sqlscript +' order by id) a)) order by id'
--exec (@v_SQL)
 set @v_SQL='select * from (select row_number() over(order by id desc) as rownum,
* from '+@v_sqlscript+') as t where t.rownum>'+str(@v_StartIndex)+' a