按条件批量修改数据


update staff_info
set department_id = b.DepartmentID
  FROM DepartmentInfo b where staff_id = b.A5 and  b.A5 in ('85936260','21321')
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/NoRoad/p/1652616.html