• HooRoo (9/11/2012)


    My colleague is under the impression that A is simply translated into B by the database anyway,

    so insists that B is preferable.

    He's correct that A is translated into B as part of the parsing. His conclusion that it's preferred however does not follow from that premise.

    They are identical, the parse to the same internal structure, so you can use whichever you prefer (and I'd prefer the first as it's a hell of a lot easier to read)

    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