I have a table A and I have defined trigger on it as following:
CREATE OR ALTER TRIGGER tr_A_IUD_FillStuff ON A
AFTER INSERT, UPDATE, DELETE AS BEGIN ... END
Now I am executing a batch in SQL Management Studio:
UPDATE [A] SET [ModifiedDateTime] = @p0
WHERE [UniqueActivityId] = @p1;
UPDATE [A] SET [ModifiedDateTime] = @p2
WHERE [UniqueActivityId] = @p3;
UPDATE [A] SET [ModifiedDateTime] = @p4
WHERE [UniqueActivityId] = @p5;
This execution fires a trigger three times. Is there any way to configure the trigger to be fired one time per a batch?