Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran
Trigger is a special type of stored procedure which is
implicitely executed when an insert , update or delete
happens on the data.
We dnt have to call trigger explicitely.
For applying some business rules we can fire trigger at
specific type.
Suppose i want a log when user inserts data on a particular
table i can use trigger.
2 types of trigger
1) DML Trigger - Applies on data -
- Instead of and After Trigger
2)DDL Trigger - Applies on database structure - on table or
database - these triggers came with sql server 2005.
Before sql server 2005 we were having only DML Triggers.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you use collections in procedure to return the resultset?
What is the max nvarchar size?
Is not null in sql?
Explain mutating table error.
What does pragma mean?
How do I clear the screen in sql plus?
What is varchar used for?
How to read/write files from pl/sql?
Which constraints we can use while creating database in sql?
What is the primary use of normalization?
What is sql select statement?
Does sql profiler affect performance?
Explain two easy sql optimizations.
What is a column in a table?
What is synchronized subquery?
