SQL Prompt - Intelligence in SQL Query Analyzer

SQL Prompt is addin developed by “Red Gate". Which have lot of Feature
to help us to write sql queries faster and with good script layout.
One of the feature I mostly liked the intelligent code completion .
I think every one like this feature.Microsoft only introduced this feature in SQL Server 2008.

See the screen shot



Feature

• Intelligent code completion for fast, accurate script building
• Script layout for easy code readability
• Cross-database and linked-server query support
• Integrates with SSMS, SSMS Express, Query Analyzer and Visual Studio
• Keyword formatting, code snippet integration, column picker and many more features

You can also download 14 days trail version from the given URL

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