22,207
社区成员
发帖
与我相关
我的任务
分享
declare @tb1 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb1
select 'a1','a2','a3'
declare @tb2 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb2
select 'B1','b2','b3'
select * from @tb1
union all
select * from @tb2
/*
col1 col2 col3
a1 a2 a3
B1 b2 b3
*/
declare @tb1 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb1
select 'a1','a2','a3'
declare @tb2 table(col1 char(2),col2 char(2),col3 char(2))
insert into @tb2
select 'B1','b2','b3'
select * from @tb1,@tb2
/*
col1 col2 col3 col1 col2 col3
a1 a2 a3 B1 b2 b3
*/
select * from a
union all
select * from b