MS SQL Server Joins Question:
Download Questions PDF

Explain Nested Trigger in SQL?

SQL Server Joins Interview Question
SQL Server Joins Interview Question

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.

Download SQL Server Joins Interview Questions And Answers PDF

Previous QuestionNext Question
Explain triggers in SQL?Explain view in SQL server?