SQL Prompt - The Must-Have Productivity Tool for SQL Developers

I am always wondering why Microsoft has not introduced intelligent editor for SQL Server. SQL Server has come a long way and with the enhancements in SQL Server Management Studio, it is anybody’s guess why it has not been incorporated. But I am using SQL Prompt for that missing functionality and it is definitely a cool tool, which gives the same feel as if we are working with Visual Studio for SQL. I hope Microsoft will include some of its features in next versions of SQL Server so that we don’t have to buy licenses of Red Gate.

Until we wait for those features in SQL Server Management Studio have a look at SQL Prompt features -  SQL Prompt Pro is a plug-in for SQL Server Management Studio, Visual Studio, and
Query Analyzer that helps to write and work with SQL more quickly. It provides code completion, along with rapid access to complete information, on the database schema, decryption of encrypted objects, and automatic formatting of SQL code. It is quick and very helpful.

Code completion: SQL Prompt provides comprehensive code completion, with support for all non-CLR SQL syntax, and automatically suggests appropriate join conditions.   
Instant access to schema information: See the schema details for objects in the suggestion list, and hover over objects in your script to see their schema definition and documentation.  
Wildcard expansion and column picker: Expand SELECT * to a complete list of columns with a single keypress, or use the column picker to quickly insert the list of columns you need.  
SQL snippets: Create snippets to insert fragments of SQL you use regularly. For example instead of typing SELECT * FROM with SQL Prompt you can just type ssf  
Statement expansion: SQL Prompt automatically completes INSERT statements with a list of column names and values, ALTER PROCEDURE statements with the procedure definition, and more.  
SQL formatting: Automatically fix the formatting of any SQL code you have to maintain. Formatting rules are configurable to match your preferred coding style.   
On-the-fly schema decryption: For databases where you have permission, SQL Prompt locally decrypts encrypted views and stored procedures and shows you their definitions.

Drawbacks: Sometimes it doesn’t display the suggestions and takes a while to read the DB schema, but thats definitely not a reason not to go with it.

References:

http://www.red-gate.com/products/SQL_Prompt/index.htm