Sql Server 2008 - BEFORE triggers?
sql-server-2008, triggers
Solution
Your client is wrong :-) Even in SQL Server 2008, there's no "BEFORE INSERT" triggers.
As Charles Bretana already mentioned: you get AFTER INSERT or INSTEAD OF INSERT triggers, but no full-fledged BEFORE triggers in SQL Server.
It's a fact for now - gotta live with it and hope for SQL Server 2008 R2 ! :-)
Marc
Problem
I've long been waiting for BEFORE triggers. But we have some systems which are written in ORACLE. When a potential new client asked why, our president told them that it was because there are no BEFORE triggers in Sql Server (among other things). To this, the client responded, "Yes, in 2008 you CAN write BEFORE triggers." Now I've heard nothing of this, not at the launch events, not in the "what's new" lists online. As far as I know, there still are no proper BEFORE triggers. Am I wrong in this? Are BEFORE triggers actually hidden in 2008 somewhere?