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!
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