【正确答案】create trigger sql_tri on employees for insert as
declare @ eid varchar(11)
declare@ name varchar(20)
declare@ deptno varchar(11)
declare yjy cursor for
select * from inserted
open yjy
fetch next from yjy into @ eid, @ name, @ deptno
while @ @ fetch_status=0
begin
update departments
set totalnumber=totalnumber+1
where deptno=@ deptno
fetch next from yjy into @ eid,@ name,@ deptno
end
close yjy
deallocate yjy