SQL Server 存储过程分页。
create proc proc_Product
@page int, -- 页数
@row int -- 一页有几行
As
declare @newpage int
set @newpage = (@page-1)*@row
select top(@row)* from Product where id not in (select top(@newpage) id from Product order by id desc) order by id desc
go
exec proc_Product 1,10
@page int, -- 页数
@row int -- 一页有几行
As
declare @newpage int
set @newpage = (@page-1)*@row
select top(@row)* from Product where id not in (select top(@newpage) id from Product order by id desc) order by id desc
go
exec proc_Product 1,10
