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?

migrated from serverfault.com Nov 20 '18 at 22:56

This question came from our site for system and network administrators.

  • 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 '18 at 22:58
  • 5
    Fix the trigger so that it doesn't return any rows. – Tara Kizer Nov 20 '18 at 23:01
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, privacy policy and cookie policy

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