create trigger tr1 on 1database..a for insert,delete as if exist(select * from inserted) and not exists(select * from deleted) insert 2database..b select * from inserted if exists(select * from deleted) and not exists(select * from inserted) delete 2database..b where column1 in (select column1 from deleted)
on 1database..a
for insert,delete
as
if exist(select * from inserted) and not exists(select * from deleted)
insert 2database..b
select * from inserted
if exists(select * from deleted) and not exists(select * from inserted)
delete 2database..b where column1 in (select column1 from deleted)