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

• Next in forum: Re: Problem in Update Trigger in SQL Server 7.0 - Need some help!
• Prev in forum: Problem in Update Trigger in SQL Server 7.0 - Need some help!
• Thread view: Re: Problem in Update Trigger in SQL Server 7.0 - Need some help!

[Reply to this message]