Posted by Erland Sommarskog on 06/19/05 11:20

Lucio Chiessi (lucio.please_no_spam@vorio.eti.br) writes:
> I'm using MS SQL Server 7.0 SP4 in some customers to store some data
> from an aplication developed by me.
> I created an trigger to run on update.
> When I run an update command on it's table and the where condition
> returns only one row, the trigger is executed ok, but if where
> condition returns more than one rows, the trigger don't run.
>
> I don't know what happens there...
> If any can help on this, I will be thankfull!

A common mistake is to believe that a trigger firers once per row. In
fact it fires once per statement.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]