#after dml trigger

When a DML statement is issued against a table, a DML trigger is fired. It can execute before or after the DML procedure depending on the condition. In this article, you'll know how to write a trigger that writes an entry into an audit table, whenever a

When a DML statement is issued against a table, a DML trigger is fired. It can execute before or after the DML procedure depending on the condition. In this article, you’ll know how to write a trigger that writes an entry into an audit table, whenever a row is inserted or updated, or deleted on the source table. CREATE TRIGGER trgEmpInsDelUpd ON Emp AFTER INSERT, UPDATE, DELETE AS BEGIN SET…