--> liangCK小梁 于2008-10-19 --> 生成测试数据: #表A IF OBJECT_ID('tempdb.dbo.#表A') IS NOT NULL DROP TABLE #表A CREATE TABLE #表A (字段A VARCHAR(2),字段B VARCHAR(2)) INSERT INTO #表A SELECT 'A1','B1' UNION ALL SELECT 'A2','B2' --> liangCK小梁 于2008-10-19 --> 生成测试数据: #表B IF OBJECT_ID('tempdb.dbo.#表B') IS NOT NULL DROP TABLE #表B CREATE TABLE #表B (字段A VARCHAR(2),字段B VARCHAR(2)) INSERT INTO #表B SELECT 'A3','B3' UNION ALL SELECT 'A4','B4'--SQL查询如下:SELECT 字段A,字段B FROM #表A UNION ALL SELECT 字段A,字段B FROM #表B ORDER BY 字段A /* 字段A 字段B ---- ---- A1 B1 A2 B2 A3 B3 A4 B4(4 行受影响)*/
SELECT 字段A,字段B FROM 表A UNION ALL SELECT 字段A,字段B FROM 表B ORDER BY 字段A
--> 生成测试数据: #表A
IF OBJECT_ID('tempdb.dbo.#表A') IS NOT NULL DROP TABLE #表A
CREATE TABLE #表A (字段A VARCHAR(2),字段B VARCHAR(2))
INSERT INTO #表A
SELECT 'A1','B1' UNION ALL
SELECT 'A2','B2'
--> liangCK小梁 于2008-10-19
--> 生成测试数据: #表B
IF OBJECT_ID('tempdb.dbo.#表B') IS NOT NULL DROP TABLE #表B
CREATE TABLE #表B (字段A VARCHAR(2),字段B VARCHAR(2))
INSERT INTO #表B
SELECT 'A3','B3' UNION ALL
SELECT 'A4','B4'--SQL查询如下:SELECT 字段A,字段B
FROM #表A
UNION ALL
SELECT 字段A,字段B
FROM #表B
ORDER BY 字段A
/*
字段A 字段B
---- ----
A1 B1
A2 B2
A3 B3
A4 B4(4 行受影响)*/
UNION ALL
SELECT 字段A,字段B FROM 表B
ORDER BY 字段A