SqlAssist supplies high quality intellisense for SQL to your Visual Studio .NET IDE.
SqlAssist is not just a quick and dirty implementation of intellisense, but a planned and well implemented product that truly increases developer productivity. SqlAssist integrates so smoothly with Visual Studio that you will quickly forget which functions belong to Visual Studio and which belong to SqlAssist. No more sifting through treeviews looking for what that table or column is named, or trying to remember exactly what you named that temp table or variable 300 lines above. No more searching "Books On Line" for what that "sp_MS" stored procedure is called. It is all at your finger tips with SqlAssist at your disposal. With knockout features like running scripts on multiple databases/servers, automatic pretty formatting, and a flexible template interface, you will come to depend on this add-in.
We have made a large time investment in making SqlAssist's intellisense list fast and convenient. It is very rare to have to wait for the contents of the list... it adjusts to the context of your cursor as fast as you type. The simple fact that just 2 or 3 characters of a table name or column name is usually enough to use type-ahead is a huge time-saver, and that equates to a substantial return on the small price that you will invest for your SqlAssist license. SqlAssist's key features include:
- Pop-up intellisense as you type, including listings of the following types:
- Table names -- user, system, and local script temp tables.
- Column names -- from user tables, system tables and local script temp tables. Column data types are displayed. Unlike other SQL intellisense programs, SqlAssist only displays columns of the table that you are referencing, even when that table has been aliased.
- Query alias names.
- Stored procedures -- user, system.
- Functions -- user, system.
- Script variables.
- T-SQL keywords, functions, global variables, etc.
- Very fast response. No waiting on the list to filter itself
- Run complex scripts right from the editor, as in Query Analyser:
- Resultsets show in a dockable output window.
- Scripts that return multiple result sets can optionally show results in a single window or each on a separate tab.
- View result set of any single SQL document while editing in another SQL document.
- Flexible Template Interface:
- Define your own templates, and organize them into a heirarchary.
- Insert the template into your document either by selecting one from a pop-up dialog, or by simply typing your user-defined abbreviation for the template right in your document.
- Share templates between developers by using a mapped network drive.
- Run scripts on multiple servers/databases:
- Interface for selecting multiple databases from multiple servers and executing a script on all in a single click.
- Interface for dynamically selecting a list of databases (through a simple query) and executing a script on all in a single click.
- Save and load server/database lists for future use.
- High quality pretty format routine:
- Handles multi-level sub-queries with ease.
- Numerous user options to have the SQL formatted the way YOU like it.
- Other miscellaneous features:
- Auto-convert single quotes to two-single-quotes when putting text in single quotes.
- Quick comment in/out several lines of text.
- Automatically add closing delimitors: ( ) [ ] { } ' ' " "
- Associate any script file with a particular database, so that each time the file is opened, it automatically connects to that database.
- Full database object browser with object scripting support.
- Many more to come...