Intellisense in SQL Server Analyzer with SQL Prompt
Always wanted intellisense in Query Analyzer? Go to the website of red-gate and try it out. The download is free till 1st of september.
SQL Prompt is also known as PromptSQL sold by Atadore SARL.
A short summary:
- Just press CTRL + SPACE to trigger intellisense. Althought it don't work perfectly sometimes;
- Recognizes related tables in a join. Note that JOIN functionality only works if you have table relationships explicitly defined in your database;
- Automatically uppercase keywords such as: select , from and etc;
- Inserts your own predefined code snippets
Related links:
