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
Is sql a dbms?
What is rowid in sql?
What are triggers and its uses?
what is the difference between truncate and delete statement? : Transact sql
what are the differences among rownum, rank and dense_rank? : Sql dba
What is equi join in sql?
What is sap sql?
Does pl/sql support create command?
What kind of join is join?
what is a composite key ? : Sql dba
When do we use triggers?
How do I view a table in sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is the location of pre_defined_functions.
What is Difference Between Unique and Primary Key Constraints?
