-- create tableCREATE TABLE TABLEA (AID INTEGER PRIMARY KEY,ANAME NVARCHAR(20))GOCREATE TABLE TABLEB (BID INTEGER PRIMARY KEY,BNAME NVARCHAR(20))GO-- build dataINSERT tableASELECT 1,'name001'UNIONSELECT 2,'name002'UNIONSELECT 3,'name003'UNION SELECT 4,'name004'INSERT TABLEBSELECT 2,NULLUNIONSELECT 3,NULLUNIONSELECT 5,NULL-- update valueUPDATE tableb SET bname = a.anameFROM tablebLEFT JOIN TABLEA AS a on tableb.bid = a.aid--不过以前好像在一篇文章说sqlserver 的update 在批量更新时，如果值不是确定的，可能会发生乱序更新的情况。太久没看了。