CREATE TRIGGER [tri_MonitorMark] ON dbo.employee
FOR INSERT, UPDATE
AS
update a
set emp_Mark=b.emp_MarkAvg*a.emp_MonitorRate
from employee a,(select emp_grp_ID,emp_MarkAvg=avg(emp_Mark) from employee x,inserted i
where i.emp_grp_ID=x.emp_grp_ID
and x.emp_MonitorRate=0
and x.emp_sc_ID=4
) as b
where a.emp_grp_ID=b.emp_grp_ID
and a.emp_MonitorRate<>0
and a.emp_sc_ID=4go--大概是这样吧,可以处理一次修改多条记录
FOR INSERT, UPDATE
AS
update a
set emp_Mark=b.emp_MarkAvg*a.emp_MonitorRate
from employee a,(select emp_grp_ID,emp_MarkAvg=avg(emp_Mark) from employee x,inserted i
where i.emp_grp_ID=x.emp_grp_ID
and x.emp_MonitorRate=0
and x.emp_sc_ID=4
) as b
where a.emp_grp_ID=b.emp_grp_ID
and a.emp_MonitorRate<>0
and a.emp_sc_ID=4go--大概是这样吧,可以处理一次修改多条记录
请大大帮忙啊