同时Update多条记录

Update Table_1
Set
 UserName=Table_2.UserName
From
Table_2,Table_1 Where Table_2.UserCode=Table_1.UserCode

 

条件：UserCode 为主键