How to create Trigger?

Surya Pratap Singh

11y1.4kSQL

What is trigger ? How to create Trigger?

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammed Ibrahim11y ago
this May help you https://msdn.microsoft.com/en-IN/library/ms189799.aspx
Upendra Pratap Shahi11y ago
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 Kushwaha11y ago
Follow this link.
-------------------------
http://www.dotnet-tricks.com/Tutorial/sqlserver/OJ97170312-Different-Types-of-SQL-Server-Triggers.html
Sumit Joshi11y ago
You can go with my refrence links and its better to learn with Practice yourself

If helpful mark as Correct answer
Rahul Prajapat11y ago
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/
Sumit Joshi11y ago
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 Saxena11y ago
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 Khan11y ago
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 Verma11y ago
http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/
Rajeesh Menoth11y ago
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 Choudhary11y ago
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/