正确答案：Create trigger sql_tri
On employees for insert
a8
declare eid varchar(11)
deekare name varehoxf20)
declare deptno varehar(11)
decl8re fly CUrsoOrfor
seleet*
from inserted
open yJy
fetch next from yJy intoeidnamedeptno
whilefeteh_status=0
begin
update departments
set to'number=totalnumber+1
where deptno=deptno
fetch next from yJy intoeidnamedeptno
end
close yJy
deallocate yJy Create trigger sql_tri
On employees for insert
a8
declare eid varchar(11)
deekare name varehoxf20)
declare deptno varehar(11)
decl8re fly CUrsoOrfor
seleet*
from inserted
open yJy
fetch next from yJy intoeid，name，deptno
while,feteh_status=0
begin
update departments
set to'number=totalnumber+1
where deptno=deptno
fetch next from yJy intoeid，name，deptno
end
close yJy
deallocate yJy 解析：此题考查了后触发型触发器的Transact_SQL语句。其语法格式为： CREATE TRIGGER触发器名称 ON I表名I视图名I [WITH ENCtlYPTION] AS SQL语句 AFTER和FOR，指定触发器只有在引发的SQL语句中指定的操作都已成功执行，并且所有的约束检查也成功完成后．才执行此触发器。即后触发型触发器。
