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
What do you mean by “trigger” in sql?
How to prepare for oracle pl sql certification?
Can two tables have same primary key?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
How to display Row Number with Records in Oracle SQL Plus?
Is sql open source?
Can we group by two columns in sql?
Do prepared statements prevent sql injection?
What is a parameter query?
Is join same as left join?
what is a primary key? : Sql dba
What are the sql aggregate functions?
What is recursive join in sql?
What are the two characteristics of a primary key?
Is nosql faster than sql?
