触发器修改与删除的操作.

Create Trigger TR_WhenUpdate On A
For Update
As
Begin
Insert B Select * From Deleted
Insert C Select * From Inserted Where 條件
End
GO
Create Trigger TR_WhenDelete On A
For Delete
As
Begin
Insert B Select * From Deleted
Delete T1 From C T1 Inner Join Deleted T2 On 關聯條件 Where 條件
End
GO