【正确答案】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 imserted
Open yjy
Fetch next from yjy into @ eid, @ name @depno
While @ @ fetch_status=0
Begin
Update departments
Set totalnumber=totalnumber+1
Where deptno=@ depno
Fetch next from yjy into @ eid, @ name @depno
End
Close yjy
Deallocate yjy