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
Why do we use procedures in pl sql?
What does truncate mean in sql?
Can a composite key be null?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Is a foreign key always unique?
What are instead of triggers?
Can you rollback after commit?
What is a trigger in sql?
Compare sql & pl/sql
What is ttitle and btitle?
How to sort the rows in sql.
How many databases can sql express handle?
Explain autonomous transaction.
What is a table in a database?
what is union, minus and interact commands? : Sql dba
