Trigger Related Problem....?
-
I have a table User_Master. I implemented a After trigger For Update on this table. When i update suppose 50 records then trigger fires 50 times but my requirement is that on updation of 50 records trigger should be fire only once.
If any body have answer help me. Thanks
-
So are you saying that something like the statement
update user_master
set field = 'x'
would cause the trigger to fire as many times as there are rows in the table? If so, please post the trigger definition.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
My guess is that the code that performs the update does not update the entire set of rows at once, instead it loops through it and updates row-by-row.
-
That was my guess too ... I just wan't going to say it yet
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
Cross-posted thread. Best answer is on this page :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311
Consider this thread closed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply