Geeks With Blogs

News Google

Nick Harrison Blog<Nick>.Next()

sqlpromptYou have probably seen this ad floating around the Internet.    Probably see it on this very blog.  

If you are already familiar with this wonderful tool, the ad makes perfect sense to you.    SQL Prompt is to Management Studio as Reshaper is to Visual Studio.

Actually, the difference is even stronger.   SQL Prompt is like upgrading from Notepad to Visual Studio.

I was first drawn to the tool for the “Format SQL” options.    Nicely formatted code is easier to understand.

Once I got started, I found many other nice features that I have found quiet handy:

  • Expand wild cards allows me to write the query as  Select * from Table but still get an itemized list of columns
  • Qualify object names allows me to get the Table.Column spelled out without me having to do all of the spelling.
  • Uppercase keywords is fairly straight forward.   I like the look but don’t always bother.    Now I don’t have to.

 

Plus you get intellisence for your queries.

As soon as I type from, I get a list of tables:

image

As soon as I type on for the join,  I get prompts for how the new table might be joined:

 

image

 

This makes it easier to crank out some SQL.   Keeps it well formatted, and also helps ensure that you have the foreign keys in place since that is how SQL Prompt figures out the options for the joins.

 

When you write an insert statement, as soon as you type out the tablename, SQL Prompt will complete that out to the full insert with each column itemized out.

 

There are also a nice little snippet manager.   You just type in a short key sequence and then <TAB> and the snippet associated with that sequence will be expanded.   Out of the box, there are several handy snippets, but you can add your own or change the built in ones.  

Give it a try, you will wonder how you ever got along without it.

Posted on Friday, February 1, 2013 10:57 AM Code Generation , SQL Tricks , Red Gate | Back to top


Comments on this post: Why you Should be Using SQL Prompt!

# re: Why you Should be Using SQL Prompt!
Requesting Gravatar...
Another option that I use is <a href="http://www.devart.com/dbforge/sql/sqlcomplete/>dbForge sqlcomplete which also provides intellisense. It has a free version.
Left by Michael Jacobsen on Feb 02, 2013 9:48 AM

# re: Why you Should be Using SQL Prompt!
Requesting Gravatar...
I like the valuable information you supply to your articles. I’ll bookmark your blog and check again here frequently. I’m fairly sure I will be informed lots of new stuff proper here! Best of luck for the following!
Left by amanda daniels on Feb 09, 2013 2:33 AM

comments powered by Disqus

Copyright © Nick Harrison | Powered by: GeeksWithBlogs.net