[dba-SQLServer] INSERT SELECT question

IME, it's been the batch.


On Mon, Jul 21, 2008 at 8:11 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...