SQL Triggers – An Introduction

CRANK

SQL Triggers – An IntroductionContentsIntroductionDifference between Stored Procedure and TriggerDML TriggersAfter TriggersSyntax of the After triggerExample of After Trigger for InsertExample of After Trigger for DeleteExample of After Trigger for UpdateInstead of TriggersDDL TriggersDDL Trigger for Create TableDDL Trigger for Alter TableDDL Trigger for Drop TableNested TriggersRecursive triggersHow to find the Triggers in a databaseHow to Disable a triggerHow to enable a triggerHow to drop a triggerReal life ExampleAdvantages of SQL TriggersDisadvantages of TriggersSummaryIntroductionTriggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are bound to specific tables. As per MSDN, triggers can be defined as the special kind of stored procedures. This article “SQL Triggers – An Introduction” will give you the detailed …