SQL Server 2000/2005
可以使用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 #
SQL Server 2000/2005
可以使用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 #