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

posted @ 2015-05-28 21:51  每天进步一点点!  阅读(194)  评论(0编辑  收藏  举报