Translate Following PL-SQL trigger to T-SQL trigger
Posted on 2004-09-01
Hi everybody. I got a question as stated in title. Is there anybody know how to translate follwing PL-SQL trigger to T-SQL trigger?
CREATE OR REPLACE TRIGGER trigger1
BEFORE UPDATE ON employee
FOR EACH ROW
WHEN (NEW.sal = 100)
-- some actions here --
Whenever any record in employee table is going to be updated to 100, some actions will be taken before that update (eg. change the new value from 100 to 120, then update the relevant records with 120 rather 100).
Thanks a lot.