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 2:35 am

    #990182

    And, heh... don't get me started on the practice of using leading commas in code.

    Oh! Come on Jeff don't be coy now :w00t:

    For the record, when I code SQL I,

    Use trailing commas

    Aliases when more than one table/subqeury

    Aliases always in subqueries

    Try to make alias meaningful (ie o for Order, ol or OrderLine etc)

    Uppercase SQL keywords

    Indent JOIN beneath FROM

    Indent ON/AND beneath JOIN (each comparison on separate line)

    Indent subqueries and subquery SQL

    Far away is close at hand in the images of elsewhere.
    Anon.