mysql与sqlserver关联更新对比

--mysql
update student s, city c
set s.city_name = c.name
where s.city_code = c.code;

--sqlserver
update t1 set t1.name = t2.name
from user_01 t1
join user_02 t2 on t1.code = t2.code
where t2.name is not null;