本文介绍了一种使用SQL存储过程实现分页查询的方法。通过定义存储过程pageData，并利用输入参数@curPage和@pageSize来动态生成SQL语句，实现从Market表中获取指定页数的数据记录。该方法适用于需要进行高效分页展示的应用场景。
Create proc [dbo].[pageData]
@curPage int,
@pageSize int
as
begin
declare @before int,@sql varchar(8000)
set @before=(@curpage-1)*@pageSize
set @sql='select top '+cast(@pageSize as varchar(10))+' * from Market where ID not in (Select top '+cast(@before as varchar(10))+' ID from Market order by ID)'
exec (@sql)
end
@curPage int,
@pageSize int
as
begin
declare @before int,@sql varchar(8000)
set @before=(@curpage-1)*@pageSize
set @sql='select top '+cast(@pageSize as varchar(10))+' * from Market where ID not in (Select top '+cast(@before as varchar(10))+' ID from Market order by ID)'
exec (@sql)
end
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
