Ms Sql Server2000分页存储过程
create procedure GetProductDetails
(
@pageindex int,
@pagesize int,
@RecordCount int output
--@docount bit
)
as
begin
set nocount on
select @RecordCount=count(ProID) from ProductDetails
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 ProID from ProductDetails order by ProID desc
select O.* from ProductDetails O,@indextable t where O.ProId=t.nid
and t.id>@PageLowerBound and t.id<=@PageUpperBound order by t.id
--
select @RecordCount
end
set nocount off
GO
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步