What are nested triggers ?
- 6 Answers
- 32241 Views
- Amazon, Appeal Soft, IBM, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
A trigger that contains data modification logic within
itself is called a nested trigger.
Use the nested triggers option to control whether an AFTER
trigger can cascade; that is, perform an action that
initiates another trigger, which initiates another trigger,
and so on. When nested triggers is set to 0, AFTER triggers
cannot cascade. When nested triggers is set to 1 (the
default), AFTER triggers can cascade to as many as 32
levels. INSTEAD OF triggers can be nested regardless of the
setting of this option.
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
what is a cursor? : Sql dba
Which sql statement is used to return only different values?
Define commit, rollback and savepoint?
What can sql server reporting services do?
What is microsoft t sql?
What is parallel hint?
What is pl sql script?
what are set operators in sql? : Sql dba
How do I run a query in pl sql developer?
Can I create table without primary key?
What is meaning of <> in sql?
Is it possible to create startup or shutdown trigger for on-schema?
What are actual parameters and formal parameters?
What is the default isolation level in sql server? : Transact sql
What are two statement types in sql?
