SQLServer分页

create procedure tb_operator_proc   
@pageSize int,      --每页的记录数   
@index int          --从第几条记录开始   
as  
  begin  
  set nocount on       
declare @sql nvarchar(3000)   
if @index>@pageSize   
     begin  
  set @index = @index - @pageSize   
       set @sql='select top '+cast (@pageSize as varchar(8))+' * from tb_operator where id>(   
          select max(id) from (select top '+cast (@index as varchar(8))+' id from tb_operator order by id)    
        as t)   
        order by id'   
  end  
else  
  begin  
      set @sql = 'select top '+cast (@pageSize as varchar(8))+'* from tb_operator order by id'   
  end  
execute sp_executesql @sql   --调用系统存储过程忧化效率    
set nocount off  
end