Home Forums SQL Server 2012 SQL Server 2012 - T-SQL how to update column city value from 'A' to 'B' and 'B' to 'A' in single query RE: how to update column city value from 'A' to 'B' and 'B' to 'A' in single query

  • October 9, 2013 at 1:44 am

    #1657015

    LutzM (10/8/2013)

    Will it be consistent/reproducable or may it vary under certain conditions (e.g. parallelism)?

    The latter. Which is why those many-one updates have such a bad rap (deservedly). It's essentially another order without an order by scenario.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass