Geek Answers Handbook

SQL Triggers: Do they run after approval or transaction?

I am looking for the answer to the question, are triggers triggered in SQL immediately after the action called by the statement, or only after the entire transaction has been completed?

+4
source share
1 answer

In SQL Server, AFTER triggers are triggered immediately after the action invoked by the statement. (A transaction can be canceled by a trigger).

There are also INSTEAD OF triggers that fire instead of a trigger action.

DML Triggers

CREATE A TRIGGER

+4
source

More articles:


All Articles