这样的SQL SERVER触发器该怎么写？

来源：百度知道 编辑：UC知道 时间：2024/05/09 17:07:38
有A，B两张表，A中含有字段a1、a2,B中含有字段b1、b2,现在要做一个触发器，当A表中a1或者a2任意一个字段插入或者删除数据时，将同样的数据插入到B表中去，a1对应b1，a2对应b2。

插入
if Exists(select name from sysobjects where type='tr' and name='A_B')
drop trigger A_B
go
create trigger A_B on A for insert
as begin
Declare @a1 int,@a2 int
select @a1=a1,@a2=a2 from inserted
insert into B values(@a1,@a2)
end

删除
if Exists(select name from sysobjects where type='tr' and name='A_B2')
drop trigger A_B2
go
create trigger A_B2 on A for delete
as begin
Declare @a1 int,@a2 int
select @a1=a1,@a2=a2 from deleted
delete from B where b1=@a1 and b2=@a2
end