--try create trigger tir_name on table1 for insert ,update ,delete as if exists(select 1 from inserted where type=2) and not exists(select 1 from deleted) insert table2 select ID from inserted else if not exists(select 1 from inserted) and exists(select 1 from deleted where type=2) delete table2 from deleted where table2.id=deleted.id else delete table2 from inserted where table2.id=inserted.id
create trigger tri_table1_insert_update on table1 for insert,update as insert table2(id) select id from inserted where type=2 delete table2 from deleted where table2.id=deleted.id and deleted.type=2go
create trigger tir_name on table1 for insert ,update ,delete as insert table2 select ID from inserted where type = 2 delete table2 from deleted where table2.id=deleted.id and deleted.type = 2
create trigger tir_name on table1
for insert ,update ,delete
as
if exists(select 1 from inserted where type=2) and not exists(select 1 from deleted)
insert table2 select ID from inserted
else if not exists(select 1 from inserted) and exists(select 1 from deleted where type=2)
delete table2 from deleted where table2.id=deleted.id
else
delete table2 from inserted where table2.id=inserted.id
on table1
for insert,update
as
insert table2(id) select id from inserted where type=2
delete table2 from deleted where table2.id=deleted.id and deleted.type=2go
for insert ,update ,delete
as
insert table2 select ID from inserted where type = 2
delete table2 from deleted where table2.id=deleted.id and deleted.type = 2