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.
v6.3 [Apr 11, 2014]
- Select in Object Explorer
- Many improvements to our SQL grammar
- UpperCamelCase and lowerCamelCase casing options
- Highlighting matching parentheses
- Template parameter dialog box now opens automatically if a snippet has parameters
- Improvements to suggestions, including:
- Suggestions box is no longer shown when there are no suggestions
- Suggestions are now shown if you continue to type a half-completed word
- More suggestions for SQL Server 2014 syntax
- Improvements to partial match suggestions
- Improved suggestion ordering (Forum post)
- Suggestions box delay option added
- Inserted and deleted tables are now suggested for triggers (and now resolve to correct table in other statements)
- Documentation for parameters of built-in functions
