¼òµ¥µÄ sql·ÖÒ³´æ´¢¹ý³Ì

¡¾1¡¿
create procedure proc_pager1  
(   @pageIndex int, -- ҪѡÔñµÚXÒ³µÄÊý¾Ý 
    @pageSize int -- ÿҳÏÔʾ¼Ç¼Êý 
)  
AS 
BEGIN 
   declare @sqlStr varchar(500)  
   set @sqlStr='select top '+convert(varchar(10),@pageSize)+  
    ' * from orders where orderid not in(select top '+  
    convert(varchar(20),(@pageIndex-1)*@pageSize)+  
    ' orderid from orders) order by orderid' 
    exec (@sqlStr)  
END 
¡¾2¡¿
 create procedure proc_pager  
(   @startIndex int,--¿ªÊ¼¼Ç¼Êý 
    @endIndex int   --½áÊø¼Ç¼Êý 
)  
as 
begin 
declare @indextable table(id int identity(1,1),nid int)  
insert into @indextable(nid) select orderid from orders order by orderid desc 
select *   
from orders o  
inner join @indextable i  
on o.orderid=i.nid  
where i.id between @startIndex and @endIndex  
order by i.id  
end 
 
¡¾3¡¿ÊÊÓÃÓÚsql2005 
create procedure proc_pager2  
(   @startIndex int,--¿ªÊ¼¼Ç¼Êý 
    @endIndex int   --½áÊø¼Ç¼Êý 
)  
as 
begin 
WITH temptbl AS   
(SELECT ROW_NUMBER() OVER (ORDER BY orderid DESC) AS Row, *from orders)  
SELECT * from temptbl  
where row between @startIndex and @endIndex  
order by row  
end