IF EXISTS (SELECT 1 FROM inserted)
IF EXISTS (SELECT 1 FROM deleted)
PRINT 'Is Update'
ELSE
PRINT 'Is Insert'
ELSE
PRINT 'Is Delete'
Basically, if there are rows in both inserted and deleted, it's an update. If there are rows only in inserted, it's an insert. If there are rows only in deleted, it's a delete.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability