SQL Prompt 9.3 release notes
Published 26 September 2018
9.3.1.6690 - October 4th 2018
Fixes
- SP-6814 : Fix for incorrectly reporting syntax errors when attempting to refactor scripts.
- SP-6819 : Fixed an issue in ALTER TABLE DROP where no columns or constraints would be suggested after selecting the first one.
- SP-6918 : Fixed a problem that could cause "Inline EXEC" refactoring to fail with a crash dialog.
9.3.0.6627 - September 26th 2018
Features
- You can now refactor INSERT statements into UPDATE statements, making it easier to update the data in your tables.
- You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt.
- Click SQL Prompt > Help > Product Learning to find how-to guides, in-depth technical articles and videos to help you uncover 'hidden gems' and make the most out of SQL Prompt.
- SQL Prompt documentation now contains a list of all keyboard shortcuts available within the product, to help you be more effective.
- When problems occur during formatting, the formatting actions that were successfully executed and those that were skipped are now displayed along with the failures.
Fixes
- SP-7208 : Fixed insert semicolon refactoring when merge statement was used as table source.