Provides an advanced IntelliSense-style code completion with a code snippet library. Aids with an easy formatting for it can format only what you need, just by simply selecting a fragment of an SQL script and starts acting on it. In the script, objects can be renamed, and many other options can be done.
SQL Prompt is a SQL IntelliSense and code-formatting tool that can be used along with MS Visual Studio. Using this tool, you can immediately spot issues that could eventually cause problems with performance, behavior, or security. It also helps you minimize delays in deployment and reduce maintenance costs. SQL Prompt's built-in static code analysis rules allow teams to check for problems automatically, during development and testing work, therefore minimizing the number of 'code smells' that creep into the application and database builds and improving build reliability.
v7.0 [Aug 28, 2015]
Check for Updates now checks for beta releases after switching back to a stable build
You can now configure connection and execution time-outs in the options
When completing a table with dot, SQL Prompt will no longer insert an alias
New experimental feature added: Change keyboard shortcut behavior for CamelCase words
New database loading and error popup
Improved trial expiry popup
When auto generating an INSERT statement SQL Prompt will now use SYSDATETIME() and SYSDATETIMEOFFSET() for DATETIME2 and DATETIMEOFFSET
Timestamp columns are no longer included in auto-generated INSERT statements
MS_Description extended properties are now displayed when connected to Azure v12
Fix for semicolon being added in the wrong position for DROP EVENT SESSION statement
Verbose logging option added to menu
Log files are now stored under %localappdata%\Red Gate\Logs\SQL Prompt 7
Tab History button is now enabled immediately after a valid serial is entered
Memory-optimized table creation scripts are now displayed in the object definition box
Columnstore indexes are now displayed correctly in the object definition box
Aggregate expressions are no longer included when expanding all non-aggregated columns
Qualify object names no longer changes invalid UPDATE statements
Columns inside an OUTPUT INTO clause are no longer qualified
Support ticket 47174: qualify object names causing UPDATE statement's table to be qualified to table alias
Support ticket 44169: Database names are now always listed in alphabetical order
Fix for SP-4240: "Command name 'TabColor_Production' is not a registered command"
