Post reply

"Prettying up" SQL Queries

  • March 7, 2006 at 1:22 pm

    #111433

    I have a bunch of legacy SQL code that is extremely ugly.  They were written by people who had no concept of what the tab key is for, and it is nearly impossible to make out the structure of the query.

    And now, to complicate matters further, there are nested selects within the queries.

    Aaarrrggghhh!  It takes too long to "pretty" them up by hand to make them readable.

    I would like some sources for cheap (free is even better) code formatters.  Ideally, it would be nice if I could also tweak the way it renders the tabs and spacing to my taste.

    Any ideas?

    Thanks, Bryan Clauss

  • March 7, 2006 at 2:18 pm

    #625279

    http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm

    is one

  • March 7, 2006 at 3:03 pm

    #625287

    WOW!  Way cool site!

    Thanks a million!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply