January 8, 2006 at 9:55 pm
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
January 9, 2006 at 2:18 am
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
January 9, 2006 at 2:24 am
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.
January 9, 2006 at 2:28 am
That was my guess too ... I just wan't going to say it yet
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
December 4, 2006 at 7:47 am
Cross-posted thread. Best answer is on this page :
http://qa.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