SqlAssist offers advanced SQL intellisense inside Sql Server Management Studio and in Microsoft Visual Studio .NET.
Edit, test, and run scripts just like you do in SQL Server Management Studio. Use SQL pretty formatting, user configurable code templates, and many shortcuts all designed to enhance your SQL coding experience and reduce development time.

Using intellisense means you no longer need to have the entire database structure in your head to be efficient. Table/view names, column names, stored procedures, user-defined and system functions, function parameter information and many other pieces of information pop up in SqlAssist's intellisense list as you work, providing you with accurate context-sensitive information when you need it. And this is just the intellisense... numerous other simple but time-saving features make editing and debugging your code a snap.
This addin has been tested in REAL WORLD settings on large implementations. We're not talking about the AdventureWorks or Northwind databases mind you... SqlAssist has been successfully used to great effect on databases that contain over 2,000 tables and 20,000 columns. And it works with SQL scripts that are over 5000 lines long, all the while continuing to provide the proper context-sensitive information in lightning-fast real-time.
SqlAssist includes several advanced features not found in other offerings, such as intellisense for variable names in your script and temp table columns created by CREATE TABLE and SELECT INTO statements.
Try SqlAssist for 30 days free... you will soon find that you cannot code without it. And for only $49, it is a must have utility for every SQL coder.