Interested to Buy Any Domain ? << Click Here >> for more details...
What are nested triggers ?
- 6 Answers
- 33990 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
Why are sql stored procedures used?
Why do we need a foreign key?
what is offset-fetch filter in tsql? : Transact sql
What are tuples in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
Can we edit a view in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What's the difference between a primary key and a clustered index?
Explain what is a field in a database and record in a database?
what is a database? : Sql dba
How to combine two stored procedures in sql?
What is scope and visibility in PL/SQL?
What is the difference between a primary key and a clustered index?
What is a boolean in sql?
Which version of sql do I have?
