Clever Geek Handbook

Sql Server 2008 - BEFORE Triggers?

I waited a long time before the triggers. But we have some systems that are written in ORACLE. When a potential new client asked why, our president told them that it was because there were no triggers on Sql Server, first of all.

To do this, the client replied, "Yes, in 2008 you CAN write BEFORE triggers."

Now I haven't heard anything about this, not about launch events, not about "new" listings on the Internet. As far as I know, there are still no proper BEFORE triggers. Am I wrong about that?

Are triggers actually hidden before in 2008?

+2


source to share


2 answers


Your client is wrong :-) Even in SQL Server 2008 there are no BEFORE INSERT triggers.

As Charles Brittany already mentioned: you get triggers AFTER INSERT or INSTEAD OF INSERT, but there are no full fledged BEFORE triggers in SQL Server.



This is a fact at the moment - you need to live with it and hope for SQL Server 2008 R2! :-)

Mark

+6


source


SQL Server (since SQL 2k5, I believe) has what is called "Instead of" triggers, which in some way appears before the trigger.



+2


source






More articles:


All Articles