SQL SERVER（42）触发器内判断事件操作

    例    根据不同的DML事件进行不同操作。
    要求当对ATriStudent表进行INSERT，UPDATE和DELETE操作时分别做出提示，并记录到日志表ATri_Log中

CREATE TRIGGER trg_ATriStudent_iud
ON  ATriStudent
AFTER  insert,update,delete
AS
IF  EXISTS (SELECT 1 FROM  inserted)  AND NOT EXISTS (SELECT 1 FROM deleted)
    BEGIN
		print '执行的是INSERT操作'
		insert  into  ATri_Log (OPER_TABLE,OPER_KD,OPER_DATE)
		values('ATriStudent','INSERT',getdate());
    END
IF EXISTS (SELECT 1 FROM  inserted)  AND  EXISTS (SELECT 1 FROM deleted)
    BEGIN
		print '执行的是UPDATE操作'
		insert into ATri_Log (OPER_TABLE, OPER_KD,OPER_DATE)
		values('ATriStudent','UPDATE',getdate());
    END
IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
    BEGIN
		print '执行的是DELETE操作'
		insert into ATri_Log(OPER_TABLE,OPER_KD,OPER_DATE)
		values('ATriStudent','DELETE', getdate());
    END