SQL Prompt™
SQL Prompt vs SSMS 2008 intellisense
| Features | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| SQL Server Support | ||
| SQL Server 2000 |  |
 |
| SQL Server 2005 |  |
 |
| SQL Server 2008 | |
|
| Editors supported | SSMS 2005 SSMS 2008 Query Analyzer Visual Studio 2005 Visual Studio 2008 |
SSMS 2008 |
| SQL formatting | |
|
| Supported SQL statements | ||
| Support for SELECT statements | |
|
| Support for CREATE statements | |
|
| Support for INSERT statements | |
|
| Support for EXEC statements | |
Limited support |
| Support for ALTER statements | |
|
| Support for DBCC statements | |
|
| Column picker to easily insert multiple columns | |
|
| Likely suggestions prioritised in the suggestions list | |
|
| Suggestion filtering by object type | |
|
| Cross-Database queries | |
|
| Linked server queries | |
|
| Automatic code generation | ||
| For INSERT statements | |
|
| For EXEC statements | |
|
| For ALTER statements | |
|
| Object decryption | |
|
| Suggests entire join conditions | |
|
| Wildcard expansion for select statements | |
|
| As you type code improvements | ||
| Prefix columns with the appropriate table | |
|
| Prefix objects with the appropriate schema | |
|
| Add aliases for tables and views | |
|
| Uppercase keywords, data types and built in functions | |
|
| Declared variables support | |
|
| Snippets | |
|
| Suggestion list includes system objects | |
|
| Tooltips | ||
| Information about database objects | Object type, summary of columns and complete definition | Object type only |
| Links directly to documentation | |
|
| Auto close quotes and brackets | |
|
| Insert parentheses for functions | |
|
