sql 分页
sql 分页
alter proc P_Order
@n int ,@m int --n条 m 页
As
select top (@n) * from dbo.[Order Details] where OrderID not in ( select top ((@m -1)*@n) OrderID from dbo.[Order Details] order by OrderID) order by OrderID
exec P_Order @n=10,@m=8