Posts
1150
Comments
891
Trackbacks
1
T-SQL - Triggers and @@Rowcount

A good tip from:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03d11.asp

Another thing you should look at from a performance standpoint is to check @@ROWCOUNT right at the beginning of the trigger. If the value is 0, that means no rows were affected by the triggering statement and executing the rest of the trigger code is unnecessary. (You should do this in any trigger.)

posted on Monday, April 25, 2005 10:14 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 1 and 7 and type the answer here: