Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of triggers ?
- 26 Answers
- 61578 Views
- Aspire, BirlaSoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / sarat
There are 4 types of Triggers
# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events
A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.
BEFORE triggers run the trigger action before the triggering
statement is run. AFTER triggers run the trigger action
after the triggering statement is run.
INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
what is sql server agent? : Sql dba
What is the example of procedure?
What is query execution plan in sql?
What is the command used to fetch the first 5 characters of a string?
Why having clause is used in sql?
what is meant by urlencode and urldocode? : Sql dba
what is 'trigger' in sql? : Sql dba
What are properties of the transaction?
Which sorts rows in sql?
What is substitution variable?
What are the types of records?
What is the difference between drop and truncate commands?
What are the uses of sysdate and user keywords?
How do I count rows in sql?
How many sql commands are there?
