表 tableA(id,name)
create procedure @beginrow int, @endrow int
as
begin
select a.id,a.name
from(
select id,name ,Row_Number() over(order by id) as row
where row>=@beginrow and row<=endrow
) as a
end
表 tableA(id,name)
create procedure @beginrow int, @endrow int
as
begin
select a.id,a.name
from(
select id,name ,Row_Number() over(order by id) as row
where row>=@beginrow and row<=endrow
) as a
end