How to get name of operation that fired trigger?

Question

Say I have a TSQL trigger

CREATE TRIGGER dbo.Trigger1 ON dbo.Table1
  AFTER INSERT, UPDATE, DELETE

How do I know which one of the above operations (insert, update, or delete) caused the trigger to fire?

Specifically, see this answer: http://stackoverflow.com/a/10928151/334849 — LittleBobbyTables - Au Revoir, Mar 07 '13 at 16:52

score 2 · Accepted Answer · edited Mar 07 '13 at 16:58

2

You could check for the existence of the inserted and deleted tables.

If only values in inserted exist, it was an insert. If only values in deleted exist, it was a delete. If both, it was an update.

edited Mar 07 '13 at 16:58

Aaron Bertrand

answered Mar 07 '13 at 16:52

Jeff Rosenberg

1

Sorry, had to edit for semantics. `inserted` and `deleted` will exist, they just may be empty depending on the action. – Aaron Bertrand Mar 07 '13 at 16:59
@Aaron I actually didn't realize that, thanks. – Jeff Rosenberg Mar 07 '13 at 17:00

1 Answers1