A trigger is a pl/sql block structure which is fired when a DML statements like Insert, Delete, Update is executed on a database table.
But 'before update' and 'after update' statement level events are fired only once per sql statement.
The above rules apply similarly for INSERT and DELETE statements.
I need to create a SQL Server trigger that will execute when a column value is updated to a specific value. In this tip, we show you how to write T-SQL statements that will create a SQL Server trigger that will execute after we update a column value to a specific value.
In the image below we see where we create our example table named tbl Trigger Test with a primary key column named pk ID, a date column named Order Approval Date Time and a varchar column named Order Status.
We populate the table with three test records with the Order Approval Date Time set to NULL and the Order Status set to "Pending".