Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/cache.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/theme.php on line 508
SQL is your friend at digitalmeandering.com
« Delerium
Mind-mapping? »

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.

Filed under Work and Random.  |

0 Responses to “SQL is your friend”

Feed for this Entry Trackback Address
  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

« Delerium
Mind-mapping? »

 

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

Links

Take it, it's good for you

wowhead

APOD


Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 86

Wunderground Weather Photo

Close up of frost


Google Ads!