Poor Man's T-SQL Formatter

I’m a bit OCD about my SQL code.

Frequently I’ll see something like

:::sql
select firstname, lastname, address1, address2, city, state, zip, homephone, cellphone, business-address1, business-address2, business-city, business-state, business-zip, business-phone, business-fax, etc.

You get the idea.

This drives me nuts.

I’d much rather see

:::sql
SELECT firstname
    ,lastname
    ,address1
    ,address2
    ,city
    ,STATE
    ,zip
    ,homephone
    ,cellphone
    ,business-address1
    ,business-address2
    ,business-city
    ,business-STATE
    ,business-zip
    ,business-phone
    ,business-fax
    ,etc.

Sometimes I’m in my SQL editor and have a code formatter available but sometimes I’m editing code on a wiki or a Word document for documentation..

Enter Poor Man’s T-SQL Formatter. This is a great plugin for SQL Server Management Studio but they also provide a stand alone website at http://poorsql.com/ which you can bookmark for easy access.

Drop in ugly query, click submit, get pretty query back.

Done.