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.4 [Sep 23, 2014]
Improvements
SQL Prompt now has less impact on Management Studio startup time
ON <owner_name> is now auto-completed for DISABLE/ENABLE TRIGGER and ALTER/DROP INDEX
Comments are now preserved when completing ALTERs
Columns and data types in object definition box are now sortable
System objects shown if fully qualified to system database
Table keyword now cased as a data type in declare statements and table-valued functions
Generated aliases are now enclosed in square brackets if option set
Management Studio intellisense is now re-enabled when SQL Prompt suggestions are disabled
Improved indentation when expanding wildcards
Improved handling of dot completion key with suggestions containing dots
Partial matching enabled for snippets
Character limit removed from create snippet text box
Bug fixes
Fix for Management Studio built-in intellisense conflicting with SQL Prompt
Fix for missing suggestions in CTE if an alias name clashes with CTE name
Generated comments are placed on the same line as data in INSERT statements if "Place commas at start" option is selected
Snippet manager now keeps edited and created snippets in view after refreshing list
Fix for ON being misaligned if table hints are used in a join clause
Scroll position is now maintained after applying Format SQL
$USER$ snippet placeholder will now resolve to the connected user rather than the windows user
Fix for formatting error with "GO 10"
Removed invalid keyword suggestions after a WAITFOR
Fix for snippet being expanded with tab while suggestions list is displayed
Synonym population won't request base types unless "Load referenced databases" option is selected (which could have been causing slow loading or timeouts)
Fix for find invalid objects with table-valued function
Fix for object tooltips on hover not displaying in Visual Studio
Fix for temp table columns not being suggested
Fix for connection details not being auto-populated in VS2010
Error dialog box is suppressed when login fails due to username/password
Views from INFORMATION_SCHEMA are no longer qualified with master
A message box is now displayed if the user doesn't have permission to reuse the password from the query's connection in SQL Prompt
SP-4277: Fix for "textViewMonitor already attached to a TextLinesMonitor" error
SP-2370: Aliases with the same names as existing database objects are now recognized as aliases
SP-2705: Wrong columns for aliases with the same names as existing table are no longer suggested
SP-2730: UPDATE statement table aliases now resolve correctly
SP-4188: Correct suggestions are now displayed before a CASE statement
SP-4443: Fixed some situations where the suggestions box didn't display properly
