34,591
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #a
(
NAME VARCHAR(20),
Age INT,
)
CREATE TABLE #b
(
NAME VARCHAR(20),
Age INT,
)
INSERT INTO #a
SELECT 'aa',20 UNION ALL
SELECT 'bb',30 UNION ALL
SELECT 'cc',20 UNION ALL
SELECT 'dd',20
--插入到b表中
INSERT INTO #b(name,Age)
SELECT * FROM #a WHERE Age=20
SELECT * FROM #b
------------------------------
NAME Age
-------------------- -----------
aa 20
cc 20
dd 20
(3 row(s) affected)