Some of you might have started using intellisense with SQL Server 2008. Intellisense is a great feature, and its something I can’t live without when I am coding.
What do you do when you are working on an older SQL Server instance ? In such scenario’s you can use Red Gate’s SQL Prompt
SQL Prompt is a tool I have used for a long time – and I highly recommend it if you spend more than a few minutes writing SQL Code.
Here are some screenshots of all it can do, the feature list is elaborate, I recommend you check it out -
Wild Card Expansion
For Example is you have
When you press TAB you get -
SQL Code Expansions
type ssf and press ENTER and you get SELECT * FROM.
This is a HUGE time saver
Press Tab and you get
There is a 14 day trial as well - http://www.red-gate.com/products/sql-development/sql-prompt/
Another tool that offers intellisense in SQL Management Studio is http://www.devart.com/dbforge/sql/sqlcomplete/, however, I personally have not used it.