可以使用union all
create table #(a int,b int)
insert into #(a,b)
select 1,2
union all
select 2,3
union all
select 3,4
select * from #
create table #(a int,b int)
insert into #(a,b)
select 1,2
union all
select 2,3
union all
select 3,4
select * from #