What is the difference between instead of trigger and after trigger?
- 1 Answers
- 1119 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vipra Verma
An Instead Of Trigger fires before the SQL statement that would normally modify a table is executed, while an After Trigger fires immediately after the SQL statement is executed. An Instead Of Trigger can prevent the modification from occurring, whereas an After Trigger cannot stop it but can perform additional actions afterwards.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to use regular expression in pattern match conditions? : Sql dba
define sql insert statement ? : Sql dba
what is sql server agent? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Can delete statement be rollbacked?
what is bcp? When does it used? : Sql dba
what are aggregate and scalar functions? : Sql dba
how to start mysql server? : Sql dba
what is schema? : Sql dba
what is dbms? : Sql dba
What is the best sql course?
Can we rollback truncate?
Can we use distinct and group by together?
how to escape special characters in sql statements? : Sql dba
what are all the common sql function? : Sql dba
