IF EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED) THEN ISUPDATE IF EXISTS(SELECT * FROM INSERTED) AND NOT EXISTS(SELECT * FROM DELETED) TNEN ISINSERT IF NOT EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED) THEN ISDELETE
THEN ISUPDATE
IF EXISTS(SELECT * FROM INSERTED) AND NOT EXISTS(SELECT * FROM DELETED)
TNEN ISINSERT
IF NOT EXISTS(SELECT * FROM INSERTED) AND EXISTS(SELECT * FROM DELETED)
THEN ISDELETE