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/archive/2010/01/20/1652616.html
转载于:https://www.cnblogs.com/NoRoad/archive/2010/01/20/1652616.html