【正确答案】Create trigger sq1_tri on employees for
insert as
Declare @ eid varchar(11)
Deelare @ name varchar(20)
Declare @ deptno varchar(11)
Declare yjy cursor for
Select*from inserted
Open yiy
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