以前在用Sql Server 2000时,老是不习惯,没有智能感知功能。编写sql的时候太慢。也不知道当时Microsoft是怎么想的。今天看了一下有位老兄写的文章。一个国外的工具,可以完成如此的功能。下载以后试了一下,果然不错啊。
http://www.red-gate.com/products/SQL_Prompt/index.htm
看一下效果图
http://www.red-gate.com/products/SQL_Prompt/index.htm
看一下效果图
Features include :
- Table/View name completion
- Column name completion
- Stored procedure name completion
- USE completion
- JOIN/JOIN ON completion
- Auto-uppercasing of keywords
- Auto-popup after keywords
SQL Prompt works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32.