Home > DeveloperSection > Interviews > What is Nested Trigger?

Posted on    October-12-2014 11:06 PM

 MSSQL Server Database  MSSQL Server 
Ratings:
 1 Answer(s)
  595  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Points:400
Posted on    October-12-2014 11:06 PM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick