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?

  • 6
    Is there an (update) trigger on the table? – ypercubeᵀᴹ Aug 20 '15 at 8:49
  • Yes precisely @ypercube. A chain of triggers is set in motion with the "simple" update :) – KirdApe Aug 20 '15 at 9:11
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, privacy policy and cookie policy

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