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

Popular posts from this blog

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

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

Inno-Setup: use own button texts on messagebox -