按条件批量修改数据


update staff_info
set department_id = b.DepartmentID
  FROM DepartmentInfo b where staff_id = b.A5 and  b.A5 in ('85936260','21321')
posted @ 2010-01-20 17:58  NoRoadZH  阅读(245)  评论(0)  编辑  收藏  举报