DECLARE @T1 TABLE(COL1 VARCHAR(1)) DECLARE @T2 TABLE(COL2 VARCHAR(5),COL3 VARCHAR(1)) INSERT @T2 SELECT 'red','A' UNION ALL SELECT 'red','B' UNION ALL SELECT 'red','C' UNION ALL SELECT 'black','A' INSERT @T1(COL1) SELECT COL3 FROM @T2 WHERE COL2='red' SELECT * FROM @T1 COL1 ---- A B C
insert into A1(username) select name from B1
用update语句吧! 这个比较好些!
update a set username= b.name from B1 b,A1 a where a.[用户ID]=b.[用户ID]
set username=b1.name
from b1
DECLARE @T2 TABLE(COL2 VARCHAR(5),COL3 VARCHAR(1))
INSERT @T2 SELECT 'red','A'
UNION ALL SELECT 'red','B'
UNION ALL SELECT 'red','C'
UNION ALL SELECT 'black','A'
INSERT @T1(COL1) SELECT COL3 FROM @T2 WHERE COL2='red'
SELECT * FROM @T1 COL1
----
A
B
C
insert into A1(username) select name from B1
这个比较好些!
update a set username=
b.name
from B1 b,A1 a
where a.[用户ID]=b.[用户ID]