好多朋友喜欢用游标解决此问题但是执行速度狂慢其实解决起来很简单了先来个简单的把FLowER的Am_employee表的email,dept_id,ext_no多条数据按emp_no对应update到EmpBaseInfo表中updateEmpBaseInfosetemailb.Mail_account,dept_idb.dept_code,ext_nob.ext_nofromflower.flower.dbo.am_employee bwhereb.emp_noEmpBaseInfo.emp_no复杂一点的多表select并将结果对应插入到指定的表中updateEmpBaseInfosetJob_Rankb.level_numberfromflower.flower.dbo.am_employee a,flower.flower.dbo.am_level b,flower.flower.dbo.am_approver_level cwherea.emp_idc.emp_idandb.level_numberc.level_numberanda.emp_noEmpBaseInfo.emp_no取别名的updatexsetJob_Rankb.level_numberfromflower.flower.dbo.am_employee a,flower.flower.dbo.am_level b,flower.flower.dbo.am_approver_level c,EmpBaseInfo xwherea.emp_idc.emp_idandb.level_numberc.level_numberanda.emp_nox.emp_no