Triggers

Question

What are triggers and how it is used in SQL Server?

Satyapriya Nayak · Answer

Hi Varshika 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