PromptSQL RC1 adds SQL Intellisense-like help to Microsoft Query Analyzer, Visual Studio 2003/2005 and Management Studio.
It suggests JOIN tables, JOIN ON conditions, and lists table columns. You don't have to remember table and column names, and relationships between tables.
Online animated demos, and a free evaluation download are available on web site.
The article continues at http://www.promptsql.com/