VI

Database

RedGate SQL Prompt 7.5.0.787

Writing SQL code by hand, even with IntelliSense, is frankly pretty dull. So we made SQL Prompt, which isn't. An add-in for SQL Server Management Studio and Visual Studio, SQL Prompt strips away the repetition of coding. As well as...

Description

Writing SQL code by hand, even with IntelliSense, is frankly pretty dull. So we made SQL Prompt, which isn't. An add-in for SQL Server Management Studio and Visual Studio, SQL Prompt strips away the repetition of coding. As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works.

Autocomplete does the work for you even for JOINs
As well as making the most common queries, such as SELECTs and INSERTs, quick to write, SQL Prompt completes JOIN conditions for you automatically. You don't have to remember any column names or aliases.

Share your snippets
Type even less by adding your own code snippets to the customizable library and sharing them with your team. That way, everyone can enjoy even faster, even easier coding.

Save and recover lost tabs in SSMS
With tab history, you can save, preview, and rename tabs and restore tabs previously opened in SSMS. Letting you pick up work where you left off and start coding again in seconds.

Safely refactor SQL code
Rename objects without breaking dependencies and encapsulate SQL code as a stored procedure.

One-click SQL code formatting
Make code readable and keep developers working to the same standards, with SQL Prompt's single-click, customizable code reformatting.

Eliminate invalid objects
Keep your databases tidy and reliable with a complete list of any invalid objects, and unused variables and parameters. To fix them, you can script objects as ALTER directly from queries.

New: Actions list
Wrap your code in a block, toggle comments, and more with SQL Prompt's new Ctrl-key actions list.

Version 7.5.0.787

Features
Support for Visual Studio 2017
Formatting improvements:
ON and WHEN keywords in MERGE statements can now be right-aligned
ELSE IF statements are now indented the same as IF statements (UserVoice)
Fix for error when formatting some server broker statements
Short ALTER TABLE statements now respects the 'Collapse Short DDL statements' option
Fix issue with parenthesised expressions sometimes removing spaces between keywords (forum)
SQL Prompt now suggests the MIXED_PAGE_ALLOCATION option (forum)
Improvements to AT TIME ZONE suggestions
Fix for connection issue in some versions of Visual Studio
Fixes
SP-6083: Fix issue when getting suggestions for tables on a linked server
SP-6190: Fix crash on startup in Visual Studio 2017
SP-6170: Fix tab history compatibility issue in SSMS 2016
SP-6160: Fixed issue with missing suggestions in Visual Studio 2013
Fix issue when installing into Visual Studio 2017 without .NET 2.0 installed (forum)
Known issues
There are two known issues with our Visual Studio 2017 support:
SQL Prompt fails to load when Data storage and processing workload is not installed
You can work around this issue by installing the Data storage and processing workload using the Visual Studio 2017 installer.
SQL Prompt Core overrides SQL Toolbelt version
You can work around this issue by installing the Data storage and processing workload without including Redgate SQL Prompt.

Additional Information