1
When a Trigger is fired after an Insert and the Insert is within a transaction, Trigger is executed at the time of the Insert or at the end of the transaction?
1 answer
1
The Trigger is triggered at the time of INSERT. The transaction is only confirmed if all the instructions INSIDE it are Successfully Completed.
Follow the hint of a reference link for study: https://docs.microsoft.com/pt-br/sql/t-sql/language-elements/transactions-sql-data-warehouse
Browser other questions tagged sql sql-server sql-server-2012
You are not signed in. Login or sign up in order to post.
The Insert is is inside the transction;
– Motta
At the time of INSERT. The transaction is only confirmed if all instructions INSIDE it are successfully completed. Ref: https://docs.microsoft.com/pt-br/sql/t-sql/language-elements/transactions-sql-data-warehouse
– Csorgo
@That’s what Csorgo is all about. If I have the time and the willingness to give you the answer, mark me that I will vote for her
– Jefferson Quesado
@Jeffersonquesado Ready. Thank you!
– Csorgo