creat trigger on 员工表
after insert
as
begin
declear @员工部门 nvarchar(20),@部门人数 int
set @员工部门 = select 部门名称 from inserted(就是刚刚插入的那条数据的部门字段)
set @部门人数 = select 部门人数 from 部门表 where 部门名称 = @员工部门
updata 部门表 set 部门人数 = @部门人数+1 where 部门名称 = @员工部门
end
这是插入时出发的触发器
begin transaction
begin try
insert into employee values(....);
update department set eCount=eCount+1 where ...
commit transaction
end try
begin catch
rollback transaction
end catch
begin transaction
begin try
insert into employee values(....);
update department set eCount=eCount+1 where ...
commit transaction
end try
begi……
[/Quote]