"SQL Prompt provides Intellisense® style auto - completion for Microsoft SQL Server editor". Thats how they describe their products. I installed it and using it. It is easy to write query in QueryAnalyser and It will tell you the exact formatting you should use for your SQL commands, while you are writing them and will therefore help you write fast, perfectly formatted SQL statements. It is not only for QueryAnalyser, we can use it inside the Visual Studio. You can download it from here untill 1st of September 2006.

SQL Image

SQL Prompt simply sits behind the scenes and provides unobtrusive help when you press Ctrl-Space or when you type "." after a table/view/alias name.

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

Have fun with this. 

Cheers…………………!