update tab1 set [Name]=B.Name
from tab1 A
left join tab2 B on A.code=B.code