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 to include character strings in sql statements? : Sql dba
What is embedded sql in db2?
What is sql in oracle?
explain advantages of innodb over myisam. : Sql dba
Can cursors be part of a trigger body?
What is tuple in sql?
Is like operator in sql case sensitive?
What does desc stand for?
How delete all data from table in sql?
Is drop table faster than truncate?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is primary key secondary key alternate key candidate key?
What is scalar function in sql?
What do you know by pl/sql cursors?
How do you identify a primary key?
