2

I'm doing a very simple datetime update in a table using its primary key:

update TABLE 
set END_DATE = '2015-10-14 00:00:00' 
where ID = 1165027;

I received the message (1 row(s) affected) 183 times!

When doing a select only one row is returned:

select * from TABLE where ID = 1165027;

What am I missing?

2
  • 6
    Is there an (update) trigger on the table? Commented Aug 20, 2015 at 8:49
  • Yes precisely @ypercube. A chain of triggers is set in motion with the "simple" update :)
    – KirdApe
    Commented Aug 20, 2015 at 9:11

1 Answer 1

3

As answered by ypercube in a comment to the question

There are one or more trigger(s) on your table.

The multiple (1 row(s) affected) messages are generated not just by your single-row update statement, but also by other statements in the triggers fired from that original action.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.