Appear in Online Interview to test your skills and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Submit content and win cash & prizes monthly.
Winners

Win Prizes

Announcements
Like us on Facebook
Sponsor
Top Articles Author
Fri, 25-Apr-2014 Authors
All Time Authors
Rajkatie
20480
Vishal@Neeraj
19600
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)

How many types of triggers are there?

 Posted by Raja on 4/16/2008 | Category: Sql Server Interview questions | Views: 11538
Answer:

There are four types of triggers.

1. Insert
2. Delete
3. Update
4. Instead of


| Alert Moderator 

Found interesting? Add this to:




Comments or Responses

Posted by: Sampath041 on: 3/30/2009

A trigger is a database object that is Bind to a table. In many aspects it is similar to a stored procedure and are often referred to as a Special kind of stored procedure.
we have many types of triggers like
After Trigger
Multiple After Triggers
Instead of Triggers
Mixing Triggers Type
After Triggers: Triggers that run after an update, insert, or delete are called after triggers.

Multiple After Triggers:More than one trigger can be defined on a table for each Insert update delete.

Instead of triggers:
Instead of triggers fire instead of the operation that fires the trigger, so if you define an Instead of trigger on a table for the delete operation, they try to delete rows, and they will not actually get deleted(unless you issue another delete instruction from within the trigger)

Login to post response.

Comments / Responses
Select text & click toolbar to format. Formatting appears in viewmode only. HTML Tags are not allowed.
Bold Italic Underline Paragraph Title Code  Link 
 Wait ... Processing ..... please wait.