Home > DeveloperSection > Interviews > What is Nested Trigger?

Posted on    October-12-2014 11:06 PM

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

Kamlakar Singh
Kamlakar Singh

Total Post:80

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