------------------------------------------------------------------------ -- Author: happyflystone -- Ver: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) -- Apr 14 2006 01:12:25 -- Copyright (c) 1988-2005 Microsoft Corporation -- Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) -- -------------------------------------------------------------------------- Test Data: T1 IF OBJECT_ID('T1') IS NOT NULL DROP TABLE T1 Go CREATE TABLE T1(a INT,b INT) Go INSERT INTO T1 SELECT 1,2 UNION ALL SELECT 2,4 UNION ALL SELECT 2,4 UNION ALL SELECT 3,5 GO -- Test Data: T2 IF OBJECT_ID('T2') IS NOT NULL DROP TABLE T2 Go CREATE TABLE T2(a INT,b INT) Go INSERT INTO T2 SELECT 3,4 UNION ALL SELECT 2,6 UNION ALL SELECT 8,2 UNION ALL SELECT 1,4 GO --Start SELECT * FROM T1 UNION ALL SELECT * FROM T2--Result: /* a b ----------- ----------- 1 2 2 4 2 4 3 5 3 4 2 6 8 2 1 4*/ --End [/code]
select * from t1 union all select * from t2
insert tb1 select * from tb2
union不是横向合并列吗?能纵向合并吗? 我试试
select * from table1 union all select * from table2
*
FROM
T1
union all
select * from t2
-- Author: happyflystone
-- Ver: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
-- Apr 14 2006 01:12:25
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
--
-------------------------------------------------------------------------- Test Data: T1
IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
Go
CREATE TABLE T1(a INT,b INT)
Go
INSERT INTO T1
SELECT 1,2 UNION ALL
SELECT 2,4 UNION ALL
SELECT 2,4 UNION ALL
SELECT 3,5
GO
-- Test Data: T2
IF OBJECT_ID('T2') IS NOT NULL
DROP TABLE T2
Go
CREATE TABLE T2(a INT,b INT)
Go
INSERT INTO T2
SELECT 3,4 UNION ALL
SELECT 2,6 UNION ALL
SELECT 8,2 UNION ALL
SELECT 1,4
GO
--Start
SELECT * FROM T1
UNION ALL
SELECT * FROM T2--Result:
/*
a b
----------- -----------
1 2
2 4
2 4
3 5
3 4
2 6
8 2
1 4*/
--End
[/code]
union all
select * from t2
select * from tb2
我试试
union all
select * from table2