The SQL trigger - timing page specifies the timing and frequency of the trigger and also the resulting correlation names.
For more information, see the following:
For each row affected by the statement Only once for the statement
For each row affected by the statement
Only once for the statement