Insert Trigger Question

[nerdalert1]

Hello all. When Selecting from the Inserted table on a trigger wont there always be just one record?

UPDATE Customer Set MailSend = 1 where CustNumb =
(SELECT CustNumb FROM INSERTED)

This is on the insert of a new record. Wont I only have one value for this each time? Somehow I am hearing this is updating multiple records.

 

[SQLSister]

The inserted table contains multiple records if multiple records are inserted. Therefore you should always write your triggers to account for this. Your code would indeed update multiple records if multiple were inserted, it would also update multiple records if custnumb is not a unique field in this table.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[nerdalert1]

Thanks SQLSister