Today I got tired of typing long SQL table names, so I figured I’d try Red-Gates’s SQL Prompt add-in for SQL Management Studio. I installed the trial version and in a matter of minutes got my first experience of “Intellisense” for SQL.
One word: Awesome!
The tool is really nice. It integrates very well into the environment, provides a ton of useful information, time saving features, and configuration options.
The demo version also includes a feature that formats the SQL code. This is pretty nice too. It makes everything the correct case, does proper line-break and indenting, etc.
To see it in action, check out their video based demo of SQL Prompt.