Answer:
A trigger can also contain INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause another data modification, thereby firing another trigger. A trigger that contains data modification logic within itself is called a nested trigger.
| Previous Question | Next Question |
| Explain triggers in SQL? | Explain view in SQL server? |