sql triggers...

TRIGGER

A TRIGGER IS A SPECIAL TYPE OF STORED PROCEDURE THAT EXECUTES OR FIRES AUTOMATICALLY WHEN AN INSERT UPDATE OR DELETE STATEMENT IS EXECUTED ON A TABLE.UNLIKE A STORED PROCEDURE WE CAN’T INVOKE A TRIGGER DIRECTLY WE CAN’T PASS PARAMETERS TO A TRIGGER AND TRIGGER CAN’T PASS BACK A RETURN VALUE.