As some of you know, I am an incredibly “lazy developer”. By that I mean, if there’s a quicker and safer way to do something I’m there!

I recently downloaded RedGate’s SQL Prompt trial version. It was 2 weeks of heaven on earth when it came to writing queries. Unfortunately my company won’t be purchasing it due to budget constraints but I’m hoping to purchase a personal version by the end of the year.

For those of you that don’t know what SQL Prompt is, it is basically intellisense for your SQL Query Analyzer. Not only does it contain snippets to perform various functions, such as insert for tables, but it also remembers joins that you make between tables! Relationships that are set in the database are automatically detected when you decide to join the table it suggests the join and you simply need to hit TAB to enter that code.

RedGate’s SQL Prompt is simply amazing! Download the trial here and give it a try: http://www.red-gate.com/products/SQL_Prompt/index.htm

Blogged with Flock