SQL Prompt
SQL Prompt eliminates the tedious parts of writing SQL, allowing us to concentrate on query design and to write queries faster. Code completion suggests and completes table and column names, and join conditions. SQL Prompt can optionally capitalise keywords, add schemas to object names, and insert aliases as we type.
Two type of edition
1) Pro
2) Standared
Some features of SQL prompt
- 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
Reference: http://www.red-gate.com/products/SQL_Prompt/index.htm