Triggers

Question

How we can Write triggers in sql2008 and how we can used these triggers in ADO dotnet2012 c# code plz answer me with example.

Shubham Kumar · Answer

Hi Sanjeev Triggers are special type of stored procedure that automatically execute when a DDL or DML statement associated with the trigger is executed. just go through with this links http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger-Instead-of-Trigger-Example.html http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/