Is there an equivalent of "Before insert" trigger of Oracle in SQL Server 2005.
I tried "Instead of" trigger but It does not actually insert into the main table and executes the statements defined in the trigger.
Currently I hav two after insert triggers in sql server both of which are getting called upon insert. I want to differentiate them as I am doing it in ORACLE by defining one of the two as BEFORE INSERT trigger.
View Complete Post