Triggers concept

Question

Hi friends..... What are triggers? How to invoke a trigger on demand? Thanks....

Satyapriya Nayak · Answer

Hi Vikas Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:10.0pt;font-family:Times New Roman;} Triggers are special kind of stored procedures that get executed automatically when an INSERT UPDATE or DELETE operation takes place on a table. Triggers cannot be invoked on demand. They get triggered only when an associated action (INSERT UPDATE and DELETE) happens on the table on which they are defined. Triggers are generally used to implement business rules auditing. Triggers can also be used to extend the referential integrity checks but wherever possible use constraints for this purpose instead of triggers as constraints are much faster Thanks

Vikas Mishra · Answer

Thanks.........