[dba-SQLServer] INSERT SELECT question

Arthur Fuller fuller.artful at gmail.com
Mon Jul 21 10:11:03 CDT 2008


If I INSERT a group of rows at once based on a SELECT from somewhere, and
the target table has an INSTEAD OF insert trigger, does that trigger fire
once for each row inserted or once for the batch of inserts?

Thanks,
Arthur



More information about the dba-SQLServer mailing list