----这里以Northwind中的orders表为例(取从M到N)
----取第100~200之间的记录
SET ROWCOUNT 100
declare @Maxid int
select @Maxid=orderid from dbo.Orders order by orderid
select @maxid
----200-100
set rowcount 100
select * from orders where orderid>@maxid order by orderid
SET ROWCOUNT 0
select orderid from dbo.Orders order by orderid