【求助】怎么样使两个表结构一样的表，把数据拼接起来形成一个表

[wly923]

例如：
表A：
id name
---------------
1 wang
2 zhang

表B：
id name
------------
1 li
2 zhao


拼接之后的临时表为

id name
------------
1 wang
2 zhang
1 li
2 zhao

用sql实现

[王向飞]

select * from table1
union all
select * from table2

[快溜]

select * from 表A
union all
select * from 表B

[幸运的意外]

select * from table1
union all
select * from table2

[Shawn]

SELECT * INTO #temp FROM dbo.A
UNION ALL
SELECT * FROM dbo.B

SELECT * FROM #temp

[liyangyang621726]

select * from table1
union all
select * from table2

[liyangyang621726]

select * from table1
union all
select * from table2