TRIGGER IN SQL SERVER
TRIGGER IN SQL SERVER:- TRIGGER are logic which can be fire's whenever we are doing INSERT ,UPDATE ,DELETE operators on TABLE. 2 different type of TRIGGER in SQL SERVER :- a. AFTER TRIGGER :-AFTER TRIGGER can be execute after the INSERT ,UPDATE, DELETE operators happen on table b. INSERTED OF TRIGGER :- INSERTED OF TRIGGER can skip INSERT ,UPDATE, DELETE and it can be execute before the update of table For creating a TRIGGER we need 2 Tables In 1st Table we will perform all the operators like INSERT UPDATE DELETE and In 2nd Table TRIGGER will fir...