create trigger mytrigger on b for insert,delete as declare @new_us_no int, @old_us_no int select @new_us_no = us_no from inserted select @old_us_no = us_no from deleted update a set us_no = @new_us_no where us_no = @old_us_no
create trigger mytrigger on b for update as declare @new_us_no int, @old_us_no int select @new_us_no = us_no from inserted select @old_us_no = us_no from deleted update a set us_no = @new_us_no where us_no = @old_us_no
create trigger mytrigger on b for insert,delete as declare @new_us_no int, @old_us_no int select @new_us_no = us_no from inserted select @old_us_no = us_no from deleted insert a(us_no) valus( @new_us_no) delete a where us_no = @old_us_no if @@error<>0 begin rollback return --插入出错,回滚事务,返回错误代码 end
for insert,delete as
declare @new_us_no int,
@old_us_no int
select @new_us_no = us_no from inserted
select @old_us_no = us_no from deleted
update a set us_no = @new_us_no
where us_no = @old_us_no
for update as
declare @new_us_no int,
@old_us_no int
select @new_us_no = us_no from inserted
select @old_us_no = us_no from deleted
update a set us_no = @new_us_no
where us_no = @old_us_no
for insert,delete as
declare @new_us_no int,
@old_us_no int
select @new_us_no = us_no from inserted
select @old_us_no = us_no from deleted
insert a(us_no) valus( @new_us_no)
delete a where us_no = @old_us_no if @@error<>0
begin
rollback
return --插入出错,回滚事务,返回错误代码
end