//Insert 触发器
create TRIGGER [dbo].[T_aa_insert] ON [dbo].[aa]
FOR INSERT
AS
DECLARE
@a1 varchar(20),
@a2 varchar(20),
@a3 varchar(20)
SELECT
@a1 = a1,
@a2 = a2,
@a3 = a3
FROM Inserted
insert into bb values(@a1,@a2,@a3);
//delete 触发器
create TRIGGER [dbo].[T_aa_delete] ON [dbo].[aa]
FOR DELETE
AS
DECLARE
@a1 varchar(20),
@a2 varchar(20),
@a3 varchar(20)
SELECT
@a1 = a1,
@a2 = a2,
@a3 = a3
FROM deleted
delete from bb
where b1=@a1 and b2=@a2 and b3=@a3
//Update触发器
create TRIGGER [dbo].[T_aa_update] ON [dbo].[aa]
FOR UPDATE
AS
DECLARE
@INSa1 varchar(20),
@INSa2 varchar(20),
@INSa3 varchar(20)
SELECT
@INSa1 = a1,
@INSa2 = a2,
@INSa3 = a3
FROM inserted
DECLARE
@DELa1 varchar(20),
@DELa2 varchar(20),
@DELa3 varchar(20)
SELECT
@DELa1 = a1,
@DELa2 = a2,
@DELa3 = a3
FROM deleted
update bb set b1=@INSa1, b2=@INSa2, b3=@INSa3
where b1=@DELa1 and b2=@DELa2 and b3=@DELa3