SqlAssist is to VS SQL text as CodeSmart is to VB 6 code - Wonderful

Wow, what a cool addin for VS 2005 to add Intellisense to your SQL queries!

Check out SqlAssist [via Hannes]

Best of all - it's in beta testing and is free to download!

some of the coolest features:

• Intellisense for tables, columns  and variables. works on temp tables and aliases just as well
• Code formatting with changeable rules
• Templates (like snippets) of SQL code with shortcut macros
• Char completion - automatically closes '(', single quotes etc. even on selected text
• Has an object explorer just like the SQL analyzer you know and love, complete with "Script to" ability.
• Works in VS 2003 and VS 2005