Sunday, December 4, 2011

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.

No comments: