Trigger firing question

[DeveloperJr]

Hey guys,

I am going blank on this one. When we insert into a table from a select statment (more than one record) if there is a trigger on that table, would it be fired for each record (one by one) or the whole insert will fire the trigger once?

 

[Otto]

Once.
You can get the records inserted in the trigger on this way:

select ... from INSERTED

 

[SQLSister]

Absolutely it will fire the whole set of records at once. If your code does not acount for multiple record inserts, it will create problems for you later on. And do not use a cursor to account for multiple records. Cursors should especially be avoided in triggers.

Questions about posting. See faq183-874

 

[DeveloperJr]

Thanks to both of you