SQL is your friend

25Oct06

I don’t know if it’s just my obsessive compulsive tendencies, but I’m a bit of a stickler when it comes to code style. It’s probably partially due to my various programming instructors all beating it into me, to the point where half your grade on coding assignments was based purely on coding style (commenting and formatting), but I digress.

I’ve had the opportunity over the past couple years to play around with SQL quite a bit, and in some cases even getting my hands dirty and writing some stored procedures. Along the way I’ve noticed that a lot of people apparently don’t like to bother with good formatting when it comes to writing SQL code (yes I know it’s not actual ‘code’) and it bugs the heck out of me when I attempt to go back and test/troubleshoot it.

Which leads me to the whole reason for this post, the Instant SQL Formatter from Gudo Software. This handy little online tool will kindly consume any SQL code you throw at it, and spit it back out all pretty-like. This can come in especially handy when you’re looking through auto-generated SQL code, which looks especially ugly. There are a number of other output modes you can select, but the one I find most handy is the HTML output (with syntax highlighting) which is very useful if you want to share some SQL code and have it more easily readable.

So go check it out and enjoy the pleasures of well formatted code.

0 Responses to “SQL is your friend”


  1. No Comments

Leave a Reply


Comment guidelines: No spamming, no profanity, and no flaming. Inappropriate comments will be deleted outright.

*
To prove you're a person (not a spam script), type the security word shown in the picture.
Anti-Spam Image




 

October 2006
M T W T F S S
« Sep   Nov »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Take it, it's good for you

wowhead

APOD

Wunderground Weather Photo

Hay Bales in Early September 2


Google Ads!