Buy Questpond's video subscriptions on
huge discount
.
Online: 2226
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
How many types of triggers are there?
Posted by
Raja
on 4/16/2008 | Category:
Sql Server Interview questions
| Views: 31808
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
There are four types of triggers.
1. Insert
2. Delete
3. Update
4. Instead of
|
Alert Moderator
Bookmark It
< Previous :
What is constraints?
Next > :
What is Clustered & Non-Clustered Index?
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
More Interview Questions by Raja
What is Clustered & Non-Clustered Index?
List few ValueTypes variables.
String is a value type or reference type?
Which statement is correct in terms of try catch finally block?
When to use String and StringBuilder class?
Write a function into Javascript that will toggle display a HTML eleme ...
How to loop through all rows of the DataTable?
What is CLR (Common Language Runtime)?
Latest Interview Questions
What is the full form of URI, URL, URN?
What is XML?
What is Document Type Definition (DTD)?
What is DOM?
What is Data Source Object?
What is complex data types?
What is CDF?
What is XSL?
More ...