SQL Prompt is available in Pro and Standard versions, or as part of a bundle.
Volume discounts apply.
SQL Prompt vs SSMS 2008 intellisense
| SQL Server Support | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| 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 |
| Supported SQL statements | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| SQL formatting | ||
| 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 | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| 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 | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| 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 | SQL Prompt 4 | SSMS 2008 native |
|---|---|---|
| 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 |
Pricing
from $195
Got a question?
0800 169 7433
Download
Try a 14-day fully functional free trial of SQL Prompt.
With our full set of SQL development tools you can code fast, collaborate easily, and deploy accurately. Sound good?
