Home » Interview » Technology

Explain Row level and statement level trigger.

Correct Answer: Row Level Trigger : Row Level Trigger is fired each time row is affected by Insert, Update or Delete command If statement doesn’t affect any row, no trigger action happens Statement Level Trigger : This kind of trigger fires when a SQL statement affects the rows of the table The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion