Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sylvia Moestl Vasilik Enhancing the readability of your code: Table aliasing in sql RE: Enhancing the readability of your code: Table aliasing in sql

  • May 7, 2009 at 10:16 am

    #990483

    tlehner (5/7/2009)

    Steve Jones - Editor (5/7/2009)

    For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:

    However, I do think that in your group, you need to be consistent. I'd hate to upper case SQL, or go with trailing commas, but I would for consistency's sake.

    My preference is to camel case tables, go with 2-4 letter aliases that are meaningful (as in ALZDBA's example), and stick with lower case for most typing.

    +1. This is almost exactly how I code SQL.

    What's up w/ the leading comma haters? I suppose you put your ands and ors at the end of a line, too? lol...

    Tim

    Heh... what's up with all the leading comma lovers? Look at the email you just wrote... no leading commas. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)