First time here? You are looking at the most recent posts. You may also want to check out older archives or the tag cloud. Please leave a comment, ask a question and consider subscribing to the latest posts via RSS. Thank you for visiting! (hide this)

Intellisense allows developers to be faster when writing code, and it can be used for almost everything inside Visual Studio, from C# code to general XML formats and CSS. But when writing SQL queries or stored procedures you have to rely only on your memory or on cut&paste.

Today I found a very cool application that enables a sort of Intellisense also when writing SQL queries. And not only in VS, but also inside Query Analyzer, Management Studio, Enterprise Manager and even UltraEdit and EditPlus.

I'm speaking about SQL Prompt by Red-Gate.

ScottGu wrote about a special offer for the old version of SQL Prompt version 2.0 almost an year ago. That version was a free download till September 2006.

But Buster Collings was kind enough to upload the installer on his website.

Of course the new SQL Prompt 3.0 has a lot more features and is also more integrated inside the editors, but since it costs 195$ I think I'll stay with the old 2.0 version

posted on Wednesday, April 11, 2007 3:47 PM

Comments on this entry:

# re: Intellisense for SQL

Left by Lorenzo Barbieri at 4/12/2007 6:09 AM

Are you sure that is legal to host a file like that? :-S

# re: Intellisense for SQL

Left by Simone at 4/12/2007 9:08 AM

mmm... not sure, probably since it has been uploaded before the end of the promotion it is.
Anyway, more legal than downloading the "pro" edition with torrent or Emule :)

# re: Intellisense for SQL

Left by Jeremy at 6/24/2007 7:04 AM

Take a look at SQL Assistant tool http://www.softtreetech.com/isql.htm . In regard to boosting developer productivity, SQL Prompt is no match to SQL Assistant, not to mention that SQL Prompt is really unusable in large databases and is also limited to SSMS and MS QA and cannot be used with other SQL editors. In comparison, SQL Assistant is fast and doesn't cache your entire database on a local disk and works with many editors and IDEs.

Comments have been closed on this topic.