--建立測試環境
Create Table T1(ID Int Identity(1,1),Name Varchar(10))
Create Table T2(ID Int ,[Desc] Varchar(10))
GO
--建立觸發器
Create Trigger Insert_T2 On T1
For Insert
As
Insert T2(ID) Select ID From Inserted
GO
Create Trigger Delete_T2 On T1
For Delete
As
Delete A From T2 A Inner Join Deleted B On A.ID=B.ID
GO
--測試
Insert T1 Select 'aa'
Union All Select 'bb'
Union All Select 'cc'
Delete From T1 Where ID=3
Insert T1 Select 'dd'
Select * From T1
Select * From T2
GO
--刪除測試環境
Drop Table T1,T2
GO
--結果
/*
ID Name
1 aa
2 bb
4 dd