Sql server old bug on update with the same colum

  • Hello

    Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

    It happens when u had something like this:

    update table_name set A = A + B from table_name

    Someone can remeber?

    Thanks

  • andrea.dimaio - Tuesday, January 31, 2017 8:05 AM

    Hello

    Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

    It happens when u had something like this:

    update table_name set A = A + B from table_name

    Someone can remeber?

    Thanks

    It's the Halloween Problem

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Luis Cazares - Tuesday, January 31, 2017 9:47 AM

    andrea.dimaio - Tuesday, January 31, 2017 8:05 AM

    Hello

    Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

    It happens when u had something like this:

    update table_name set A = A + B from table_name

    Someone can remeber?

    Thanks

    It's the Halloween Problem

    Great!!!!

    I was not sleeping to remeber that!!

    Thanks a lot 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply