Friday, March 23, 2012

Insert trigger for bulk insert

In case of a bulk insert, the "FOR INSERT" trigger fires for each recod or only once?

Thanks,

(FIRE_TRIGGERS
Specifies that any insert triggers defined on the destination table execute during the bulk-import operation. If triggers are defined for INSERT operations on the target table, they are fired for every completed batch.

If FIRE_TRIGGERS is not specified, no insert triggers execute.

For more information, see Controlling Trigger Execution When Bulk Importing Data. )

What you are looking for is in the BOL(books online). Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms188365.aspx

sql

No comments:

Post a Comment