(
select *from table1
union all
select *from table2
)
into #temp3....................这样的语句应该怎么写
也就是说如何把union 得到的结果放到临时表中去
------解决方案--------------------
- SQL code
select * into # from ( select *from table1 union all select *from table2 ) t
------解决方案--------------------
- SQL code
CREATE TABLE #A (ID INT, AMT INT, S_DATE VARCHAR(10))INSERT #ASELECT 1, 3000, '2008-11-21' UNION ALL SELECT 1, 5000, '2008-11-19' UNION ALL SELECT 2, 4000, '2008-11-17' UNION ALL SELECT 2, 6000, '2008-11-19' UNION ALL SELECT 3, 1000, '2008-10-12' UNION ALL SELECT 3, 200, '2008-11-02'CREATE TABLE #B (ID INT, AMT INT, S_DATE VARCHAR(10))INSERT #BSELECT 1, 3000, '2008-11-21' UNION ALL SELECT 1, 5000, '2008-11-19' UNION ALL SELECT 2, 4000, '2008-11-17' UNION ALL SELECT 2, 6000, '2008-11-19' UNION ALL SELECT 3, 1000, '2008-10-12' UNION ALL SELECT 3, 200, '2008-11-02'SELECT * INTO #C FROM (SELECT * FROM #AUNION ALLSELECT * FROM #B)ASELECT * FROM #CDROP TABLE #A,#B/**ID AMT S_DATE ----------- ----------- ---------- 1 3000 2008-11-211 5000 2008-11-192 4000 2008-11-172 6000 2008-11-193 1000 2008-10-123 200 2008-11-021 3000 2008-11-211 5000 2008-11-192 4000 2008-11-172 6000 2008-11-193 1000 2008-10-123 200 2008-11-02