3

I'm running the following update command

UPDATE table
SET [End] = '2018-12-17'
WHERE (ID = '5b010204-c12c-4b38-8d28-affe11684da0')

This will give the following result:
enter image description here

What can cause this on SQL server 14?

2
  • There are update triggers updating some other records in the table when the [end] column is updated. Is there some way to not return these rows?
    – Mr Zach
    Nov 20, 2018 at 22:58
  • 5
    Fix the trigger so that it doesn't return any rows.
    – Tara Kizer
    Nov 20, 2018 at 23:01

1 Answer 1

7

This is due to an UPDATE trigger that has a SELECT in it. Modify the trigger so that it doesn't return any rows.

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.