关于update刷新表,表1和表2

[wave_f]

表1的结构是:代号 , 简称,地址,电话
S001 同达 .... ...
S002 创新 .......
S003 ..

表2的结构是:代号 , 新代号
S001 SN20
S002 SN21

我想把用表2中的新代号全部刷新表1的代号,如何写这条语句?

[ff117]

S1(ID,NAME) S2(ID,NEWID)

UPDATE S1 SET A.ID=B.NEWID FROM S1 A,S2 B WHERE A.ID=B.ID

[chuifengde]

update table1 set 代号=table2.新代号 from table1 Inner Join table2 On table1.代号=table2.代号

[berwos]

update t1 set 代号=t2.新代号 from t1 Inner Join t2 On t1.代号=t2.代号

[zjcxc]

UPDATE A SET
ID=B.NEWID
FROM S1 A,S2 B
WHERE A.ID=B.ID

[zjcxc]

UPDATE S1 SET ID = (SELECT TOP 1 NEWID FROM S2 WHERE S1.ID=S2.ID)

[shazi_pig]

CREATE TABLE #temp1(Idno int,tname varchar(10))
CREATE TABLE #TEMP2(IDNO INT,NEWIDNO INT)

INSERT #TEMP1 SELECT 101,'AAA' UNION ALL
SELECT 102,'BBB' UNION ALL
SELECT 103,'CCC'

INSERT #TEMP2 SELECT 101,201 UNION ALL
SELECT 102,202 UNION ALL
SELECT 103,203
UPDATE #TEMP1 SET IDNO=NEWIDNO FROM #TEMP1,#TEMP2 WHERE #TEMP1.IDNO=#TEMP2.IDNO