Satyapriya Nayak14y agoPosted Jul 6, 2012, 6:05 AMHi Nitin,Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table. Triggers can't be invoked on demand. They get triggered when the associated INSERT, DELETE or UPDATE is performed.Please refer the below linkshttp://www.c-sharpcorner.com/uploadfile/shashikantray/create-delete-and-update-triggers-in-a-database/default.aspxhttp://www.codeproject.com/Articles/25600/Triggers-Sql-ServerThanks
Satyapriya NayakPosted Jul 6, 2012, 6:05 AM
Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.
Triggers can't be invoked on demand. They get triggered when the associated INSERT, DELETE or UPDATE is performed.
Please refer the below links
http://www.c-sharpcorner.com/uploadfile/shashikantray/create-delete-and-update-triggers-in-a-database/default.aspx
http://www.codeproject.com/Articles/25600/Triggers-Sql-Server
Thanks