MS SQL Server Joins Interview Question:

Explain Nested Trigger in SQL?

Submitted by: Muhammad

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.
Submitted by: Muhammad