Tag Archives: 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

Difference between Stored Procedure and Trigger

Posted on November 1, 2018 by vivekjohari

Difference between Stored Procedure and Trigger     SQL Stored Procedure & SQL Triggers, both are the important objects of SQL. SQL stored procedure are the set of logically group of SQL statements which are a group to perform a … Continue reading →

Posted in Imp SQL Difference, SQL Server, SQL Stored Procedure | Tagged , , , | 15 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