SQL Prompt provides an intelligent-aware form of auto-complete function for the Microsoft SQL Server editor. When you are writing your own SQL commands, it will also tell you the correct format to use, helping you quickly write well-formatted SQL statement. SQL Prompt will increase your productivity in creating any SQL script.
Features:
Table/View name completion Column name completion Stored procedure name completion
USE completed
JOIN/JOIN ON completes automatic conversion of keywords into uppercase letters
Automatically pops up after keywords
SQL Prompt support:
1.Visual Studio 2005
2.Visual Studio 2003
3.SQL Server 2000 Enterprise Manager
4.Microsoft Query Analyzer
5.UltraEdit32
6.EditPlus
r2005 is also supported (it is not written on its official website, but I tried it and it worked).
Please go to the official website to download it for free! !
http://www.red-gate.com/products/SQL_Prompt/index.htm
If it doesn’t work, I will also have the latest version on my blog.