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