Posts
808
Comments
670
Trackbacks
1
T-SQL - Triggers and @

A good tip from:

Another thing you should look at from a performance standpoint is to check @ 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
Comments
No comments posted yet.

Post Comment

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