SQL Update Behaviour

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  July 7, 2011 at 8:55 am

  #1349760

  SQLkiwi (7/7/2011)

  ---

  Hi John,

  There was an interesting discussion on Connect over Hugo Kornelis' request to deprecate UPDATE...FROM:

  http://connect.microsoft.com/SQLServer/feedback/details/332437/deprecate-update-from-and-delete-from

  Thanks Paul. Seems to be a very partisan discussion. I think I'm on Hugo's side, but I don't have enough experience of using MERGE to be aware of its pitfalls.

  John