CREATE procedure pagination12222
(@pagesize int, --頁面大小，如每頁存儲20條記錄
@pageindex int --當前頁碼
)
as
set nocount on
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 hhh from BEFORE_A
order by HHH desc
select O.hhh,O.lblh,O.lblm,O.dwmc,O.yljy from BEFORE_A O,@indextable t
?????????? where O.hhh=t.nid and t.id>@PageLowerBound
??????????????????????? and t.id<=@PageUpperBound order by t.id
end
set nocount off
GO