SQL Prompt–Intellisense for SQL Server and more

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.

INSERT Statements

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.

Read More:
SQL Prompt–Intellisense for SQL Server and more