How do I create a BEFORE trigger on a table still have the AFTER trigger working?
I just noticed there is only the INSTEAD OF and AFTER trigger, can we create a BEFORE trigger with the SF?
Solved
BEFORE trigger
+16Best answer by Mark Jongeling
Hi Freddy,
To my knowledge, SQL Server does not have Before triggers. You can write an Instead-of-trigger that first does the queries that you would like to put in the before trigger, thereafter do the actual operation, f.e. Inserting the data, and lastly run the queries that are now part of the After trigger.
Some more information I found here: https://databasefaqs.com/sql-server-trigger-before-insert/
Does that help?
This topic has been closed for comments
+23Hi Freddy,
To my knowledge, SQL Server does not have Before triggers. You can write an Instead-of-trigger that first does the queries that you would like to put in the before trigger, thereafter do the actual operation, f.e. Inserting the data, and lastly run the queries that are now part of the After trigger.
Some more information I found here: https://databasefaqs.com/sql-server-trigger-before-insert/
Does that help?
"Wake me up before you low-code"
1 person likes this
+16Mark Jongeling wrote:
Hi Freddy,
To my knowledge, SQL Server does not have Before triggers. You can write an Instead-of-trigger that first does the queries that you would like to put in the before trigger, thereafter do the actual operation, f.e. Inserting the data, and lastly run the queries that are now part of the After trigger.
Some more information I found here: https://databasefaqs.com/sql-server-trigger-before-insert/
Does that help?
Yes, I am mistaken. On DB2 it does have a before, on SQL Server it's the instead of trigger that completely replaces the (after) trigger on SQL server.
I am up to date again :)
LEF — Lift. Empower. Fulfill. [lef.digital]
1 person likes this
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.