Released: May 19, 2016

Updates in this release

Updates in 7.2.2.273

• Fix for incorrect $CURSOR$ placeholder location in the 'curff' default snippet
• SP-5694: Fix for null reference exception being thrown on invalid computed column syntax

Released: Apr 27, 2016

Updates in this release

Updates in 7.2.1267

• Execution warnings are no longer shown when modifying an aliased temp table
• Format SQL is now included in the right click context menu in SSMS2016
• Fix for issue with high-DPI mode in SSMS2008R2 under Windows 8.1 and 10
• Fix for wildcards not expanding on certain scripts
• Support ticket 65031: Fix for tab history not restoring tabs if nosplash argument is passed to SSMS on the command line

Released: Apr 19, 2016

Updates in this release

Updates in 7.2.0.260

SSMS 2016 support
SQL Prompt now supports SSMS April 2016 Preview.

SQL Prompt 7.2 works with SSMS April 2016 Preview and SSMS March 2016 Preview Refresh, but won't work with earlier SSMS 2016 preview versions.

Execution warnings
SQL Prompt now shows a warning message when you try to execute an UPDATE or DELETE statement without a WHERE clause.
Warnings aren't shown when modifying temporary tables or table variables.

Suggestions improvements

• SQL Prompt now offers suggestions...

Released: Mar 8, 2016

Updates in this release

Updates in 7.1

Features
These features are available in Management Studio and Visual Studio 2012 and later.

• From the Results grid, you can now:
  • Copy results as an IN clause
  • Script results as an INSERT statement
  • Open results in Excel
• Highlight matching objects - When you place the caret on an object in a script, SQL Prompt now highlights all usages of that object.

Suggestions improvements
SQL Prompt now offers suggestions for the following SQL Server 2016 syntax:

• Row-level security (MSDN)
• Dynamic...

Released: Aug 18, 2015

Updates in this release

Updates in 7.0

Environment support
You can now use SQL Prompt in:

• Management Studio 2016 CTP2
• Visual Studio 2015

The following features are now available in Visual Studio 2012 or later:

• Find invalid objects
• Script as ALTER
• Execute current statement
• Rename variables/aliases
• Encapsulate as new stored procedure
• Split table

Red Gate removed support for Visual Studio 2005 and 2008.

Snippet manager improvements
You can now create your own placeholders in snippets.

Actions list
When you select some...

Released: Feb 11, 2014

Updates in this release

Updates in 6.2

• SQL Server Management Studio 2014 support.
• SQL Server 2014 CTP2 support.
• SQL Prompt now connects to SQL Server 2014 and suggests new syntax.
• Phrase completion. SQL Prompt now completes entire SQL phrases.
• Insert suggestions by pressing the semicolon (;) key.
• Tabs opened by SQL Prompt are no longer marked as unsaved.
• Options dialog box is now resizable.
• Improved formatting for MERGE statements.

Released: Dec 2, 2013

Updates in this release

Updates in 6.1

• Server/database connection filtering. You can now specify the databases you want SQL Prompt to load suggestions for.
• Synonyms (including columns from a synonym’s base object) are now suggested.
• CLR functions and CLR stored procedures are now suggested.
• XML functions are now suggested and fully supported.
• SQL Azure databases are now supported.
• Keep a history of query tabs you open in SQL Server Management Studio.
• You can now share snippets with other SQL Prompt users by using a...

Released: Feb 11, 2011

Updates in this release

Updates in 5.0

• Find Invalid Objects
  SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.
• Script Object as ALTER from a query window
  If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.
• View...