tablea必须有主键,假设是columna:
create procedure a_proc
(@min int=1,
@max int=1
)
as
begin
select IDENTITY(int, 1,1) AS ID,* into #tmp_1 from tablea order by columna
select * from #tmp_1 where ID between @min and @max order by ID
end
return(0)
----------------------------------------------------
是要这个吗?