select @num_worker=(select department from department where num_worker=(select worker_name from inserted) )
------>
select @num_worker=(select num_worker from department where worker_name=(select worker_name from inserted) ) 这个触发器太乱了,以后还会有问题
------>
select @num_worker=(select num_worker from department where worker_name=(select worker_name from inserted) ) 这个触发器太乱了,以后还会有问题
as begin
select department,worker_name=max(worker_name),num_worker=count(*)
into #Temp
from inserted
group by departmentupdate d
set num_worker=d.num_worker+t.num_worker
from department d ,#Temp t
where d.department=t.departmentinsert into department
select department,worker_name,null,num_worker
from #Temp t
where not exists (
select * from department d
where d.department=t.department
)
end
go