--插入动作
IF NOT EXISTS(SELECT 1 FROM DELETED)
--删除动作
IF NOT EXISTS(SELECT 1 FROM INSERTED)
--修改动作
IF EXISTS(SELECT 1 FROM INSERTED) AND EXISTS(SELECT 1 FROM DELETED)
--插入动作
IF NOT EXISTS(SELECT 1 FROM DELETED)
--删除动作
IF NOT EXISTS(SELECT 1 FROM INSERTED)
--修改动作
IF EXISTS(SELECT 1 FROM INSERTED) AND EXISTS(SELECT 1 FROM DELETED)