“从M开始到N”是什么意思?是id 在M开始到N之间?create proc pr_test @m int, @n int as select * from a where id between @m and @n go还是表的M到N条记录?create proc pr_test @m int, @n int as declare @sql varchar(8000) set @sql=' select top '+cast(@N-@M as varchar(30))+' * from ( select top '+cast(@N as varchar(30))+' * from a order by id asc ) as t order by id desc ' exec (@sql) go
@m int,
@n int
as
select * from a where id between @m and @n
go还是表的M到N条记录?create proc pr_test
@m int,
@n int
as
declare @sql varchar(8000)
set @sql='
select top '+cast(@N-@M as varchar(30))+' * from (
select top '+cast(@N as varchar(30))+' * from a order by id asc
) as t
order by id desc
'
exec (@sql)
go