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