Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
T-SQL Trigger/SQL Server 7.0
Message
From
01/07/2002 18:56:35
Michael Levy
Cincinnati, Ohio, United States
 
 
To
28/06/2002 11:45:00
Daniel Gramunt
Nokia
Lausanne, Switzerland
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: T-SQL Trigger/SQL Server 7.0
Miscellaneous
Thread ID:
00672425
Message ID:
00674180
Views:
31
Just remember that a SQL Server trigger fires ONCE no matter how many rows are affected by the query - one, five, or even zero. After you UNION the Inserted and Deleted columns, it may not be enough to just refernce @@ROWCOUNT.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform