[I'm way overdue talking about this one... ]
A couple weeks ago I was contacted by a company (SoftTree) because they have a product which is a competitor to the Redgate's SQL Prompt and RoundedPolygons SQLAssist (see this post by me).
Basically It does everything that both tools do, intellisense in your SQL tools and in Visual Studio. Like the original SQLPrompt (does version 3 do this), you can get SQL intellisense in all kinds of places... not just inside the standard SQL tools.
Like SQLAssist it offers templates so you can type a few keystrokes and get code stubbed out for you.
What does it add?
I was shocked when I tried this thing... First of all if you remember the old SQLPrompt was notoriously slow. SQL Assistant is is very snappy. I've noticed an occasional slow down (but the hardware I'm running this on is less than optimal).
Ok, so now this thing that blew me away. It sports SQL vocabularies for T-SQL, PL-SQL (Oracle), DB2, and MySQL (I wish you guys had PGSQL --Postgres). So if you find yourself using multiple database products this is the tool for you. Obviously it hooks its way into all the necessary tools for these individual DB products.
I was looking at their web site and they have a plugin api that you can use to apply SQL intellisense to your own apps.
It's priced between the other 2 products at $149... It's hard to choose between this and Red Gate's package with SQL Prompt and SQL Refactor.
The truth is I have a new favorite in the arena of SQL intellisense: SQL Assistant.