批量修改部门名称(根据部门代码)
update dcc_internal_file
set dcc_internal_file.dept_name=t_s_depart.departname
from dcc_internal_file inner join t_s_depart
on dcc_internal_file.dept_code=t_s_depart.id
批量修改部门名称(根据部门代码)
update dcc_internal_file
set dcc_internal_file.dept_name=t_s_depart.departname
from dcc_internal_file inner join t_s_depart
on dcc_internal_file.dept_code=t_s_depart.id