Test your technical skills online, appear in Virtual Interview and be ready for job!
Twitter Twitter LinkedIn YouTube Google
Be Interview ready ! | Search
Make friends on DotNetFunda.com and expand your network!

Win Prizes

Like us on Facebook
Top Articles Author
Wed, 23-Apr-2014 Authors
All Time Authors
Bharathi Cherukuri

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: 11526

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.