sql server - Insert Update trigger how to determine if insert or update - Stack Overflow

If it's MS SQL Server... Triggers have special INSERTED and DELETED tables to track "before" and "after" data. So you can use something like IF EXISTS (SELECT * FROM DELETED) to detect an update. You only have rows in DELETED on update, but there are ...

stackoverflow.com