Home Forums SQL Server 2008 T-SQL (SS2K8) Best way to UPDATE with join to other tables... RE: Best way to UPDATE with join to other tables...

  • October 21, 2013 at 9:27 am

    #1660168

    Kurt W. Zimmerman (10/21/2013)

    Luis Cazares (10/21/2013)

    Locks will happen on both updates. The difference might be the JOIN type which uses different standards. The first query uses ANSI-92 standard and the second one uses ANSI-89 standard. AFAIK, both queries will be interpreted the same way.

    OK, so looking at both queries I'd have to say I'm "old school" cuz I would have written it the second way. :Whistling:

    I would suggest you to change your habits as the outer joins in the ANSI-89 standard are no longer supported on SQL Server. Who knows, maybe they'll force complete ANSI-92 standard in future versions.

    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