stored procedures - Trigger is not fired multiple time in sql server -

-

i have trigger on table, trigger on update of row.

i have 10 rows in table.

i updating rows condition within stored procedure.

i have seen trigger got triggered once.

but need run trigger each , every update of each row.

can please me on this.

in trigger, have table inserted same schema triggered table in you'll find 10 rows inserted/updated. can make batch treatment. other way, can iterate on temp table single treatment.


Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

wpf - C# NAudio - Changing audio playback position still plays a small buffer of old position -

-
i trying make basic mp3 player in c# , wpf, along naudio. added slider tracks current position in song allows drag different position , upon thumb.dragcompleted set song's position dragged it. this works fine , all, except when make jump new position, still plays old position 1/5th or of second before changing. noticeable e.g. while singer in middle of singing "aaa", pause, drag point sings "ooo", play again, hear "aa-ooo". results in sounding pretty horrible. so suppose audio playback has small 'buffer' remaining insists on playing before moving on. there way clear buffer? or setting position wrong? i using waveout waveoutdevice , audiofilereader audiofilereader . slider called sldrplaybackprogress . tried change position in song in 2 different ways already: first method: audiofilereader.currenttime = new timespan(0, (int)(math.floor(sldrplaybackprogress.value / 60)), (int)(math.floor(sldrplaybackprogress.value % 60))); sec...
Read more

Inno-Setup: use own button texts on messagebox -

-
it common practice in gui design not use yes-no-messageboxes give buttons real names, e.g. save or discard. how can achieve in messageboxes displayed msgbox in innosetup, @ least ones show in code section? the msgbox function uses internally messagebox windows api function allows use specific set of predefined buttons or button groups. what's worse, buttons cannot localized (without hook like this ). so, have custom button texts need use such hook , change texts before showing dialog, show dialog , after change them common texts (because inno setup uses dialog too). another, easier option making custom form.
Read more