How to create Trigger?

Question

What is trigger ? How to create Trigger?

Rahul Prajapat · Answer

Trigger is a self invoking stored procedure associated with a Table. Trigger automatically invoke whenever a specified event is occurs on the table. We can not execute the trigger explicitly. Trigger is used to maintain data integrity, and to perform any operation before and after executing the DML or DDL query. Syntax to Create a trigger : CREATE [OR REPLACE ] TRIGGER Trigger_Name ON Table_Name {BEFORE | AFTER | INSTEAD OF } {INSERT [OR] | UPDATE [OR] | DELETE} AS Begin Declaration Part { } Select Part { // Initialize Variables } Executable-Code EXCEPTION Exception-Handling-Code END; For more detail about trigger, You can refer this article: http://www.c-sharpcorner.com/UploadFile/f0b2ed/trigger-in-sql/

Mohammed Ibrahim · Answer

this May help you https://msdn.microsoft.com/en-IN/library/ms189799.aspx

Upendra Pratap Shahi · Answer

Hello, Kindly go through below link- http://www.codeproject.com/Articles/25600/Triggers-SQL-Server http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/ http://blog.sqlauthority.com/category/sql-trigger/

Hemlata Kushwaha · Answer

Follow this link. ------------------------- http://www.dotnet-tricks.com/Tutorial/sqlserver/OJ97170312-Different-Types-of-SQL-Server-Triggers.html

Sumit Joshi · Answer

You can go with my refrence links and its better to learn with Practice yourself If helpful mark as Correct answer

Sumit Joshi · Answer

Hi Surya, Below are the links to help you http://www.codeproject.com/Articles/25600/Triggers-SQL-Server http://www.dotnet-tricks.com/Tutorial/sqlserver/OJ97170312-Different-Types-of-SQL-Server-Triggers.html If found helpful mark as Correct Answer

Shakti Saxena · Answer

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected

Basit Khan · Answer

Trigger is nothing but action, for an example if you want to send email after inserting record in your table then you can use the trigger, you can use for many purpose. Below is the code. create TRIGGER ON [dbo]. FOR INSERT AS BEGIN SET NOCOUNT ON; IF EXISTS (SELECT * FROM inserted) BEGIN // do your code END END GO

Amitesh Verma · Answer

http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/

Rajeesh Menoth · Answer

Hi, Read this article : 1) http://www.codeproject.com/Articles/25600/Triggers-SQL-Server 2) http://www.tutorialspoint.com/plsql/plsql_triggers.htm

Pankaj Kumar Choudhary · Answer

Hello @Surya Triggers are stored programs that are automatically executed or fired when some events occur. It is a database object that is bound to a table and is executed automatically. We cannot explicitly call any trigger. Triggers provide data integrity and used to access and check data before and after modification using DDL or DML query. You can ready my article for this http://www.c-sharpcorner.com/UploadFile/f0b2ed/trigger-in-sql/

How to create Trigger?

Answers (11)