Inadvertently found this good tool from a blog abroad, can't wait to recommend to everyone this completely free SQL intelliisense Prompt tool (http://www.red-gate.com/products/ SQL _prompt/index.htm), preliminary use, it can indeed improve production efficiency. Currently, this tool only supports English versions (Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio. NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32, EditPlus ). The implementation principle of this tool is a bit similar to Kingsoft. Using the Hook Technology, it locates the target SQL editing window through FindWindows and matches the content in the window title bar. After the window is hooked, the SQL script entered by the user is intercepted. Therefore, if you are currently using SQL Query Analyser in Chinese, you need to switch to the English environment (Open C: \ Program Files \ Microsoft SQL Server \ 80 \ Tools \ Binn \ Resources, rename the 2052 folder name to another name, for example, 2052tmp, and re-open SqlQueryAnalyser to the English version.) only in this way can this tool be used for intelligent sensing!
Other similar products: SQL Assist http://www.roundpolygons.com/, but not free, and only inMicrosoft Visual Studio. net ide.In use.
SoftTree SQL Assistant-for Oracle and SQL Server
Microsoft SQL Query Analyzer example
Click image to enlarge |
|
Oracle SQL * Plus example
|