SELECT第M行开始的N行数据，怎么写？

[km168]

我需要选出从第M行开始的N行数据，即第M行到M+N-1行，存储过程怎么写？M和N为参数，由外部给出

[伍子V5]

CREATE procedure pd_name @M int,@N int
as
declare @Count int
set @Count=@M+@N
exec ('select top '+@N+' * from (select top '+@Count+' * from tablename order by ID) a order by a.ID desc')
GO

[pengdali]

select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20

[shaken]

先确定一个ID序列(自增长Identity)字段，然后根据序列号判断。直接判断在mssql据我所知不行的。