高效率的分页存储过程

CREATE   procedure   ProRobin  
  (@pagesize   int,  
  @pageindex   int,  
  @docount   bit)  
  as  
  set   nocount   on  
  if(@docount=1)  
  select   count(wzxxbm)   from   YBFLD  
  else  
  begin  
  declare   @indextable   table(id   int   identity(1,1),nid   int)  
  declare   @PageLowerBound   int  
  declare   @PageUpperBound   int  
  set   @PageLowerBound=(@pageindex-1)*@pagesize  
  set   @PageUpperBound=@PageLowerBound+@pagesize  
  set   rowcount   @PageUpperBound  
  insert   into   @indextable(nid)   select   wzxxbm   from   YBFLD   order   by   xlh   desc  
  select   O.*   from   YBFLD   O,@indextable   t   where   O.wzxxbm=t.nid  
  and   t.id>@PageLowerBound   and   t.id<=@PageUpperBound   order   by   t.id  
  end  
  set   nocount   off  
  GO