Category Archives: SQL Triggers

Articles about SQL Triggers

SQL Triggers – An Introduction

Posted on December 8, 2018 by vivekjohari

SQL Triggers – An Introduction Contents Introduction Magic Tables Difference between Stored Procedure and Trigger DML Triggers After Triggers Syntax of the After trigger Example of After Trigger for Insert Example of After Trigger for Delete Example of After Trigger … Continue reading →

Posted in Most Imp SQL Concepts, SQL Advanced, SQL Server, SQL Triggers | Tagged , , , , | 33 Comments

Advantages & Disadvantages of SQL Trigger

Posted on November 1, 2018 by vivekjohari

Advantages & Disadvantages of SQL Trigger Introduction Triggers are database objects which are needed to perform some predefined action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are … Continue reading →

Posted in SQL Server, SQL Triggers | Tagged , | Leave a comment

SQL Script to find all the triggers defined on a database or on a single table

Posted on August 14, 2015 by vivekjohari

SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] , trig.name as [Trigger Name] … Continue reading →

Posted in SQL Advanced, SQL Tips, SQL Triggers | Tagged , | 30 Comments