SQL Prompt 6.4 release notes
Published 12 September 2014
Version 6.4.0 - September 16th, 2014
Execute current statement
In a query window, you can now execute the SQL statement under your cursor by pressing Shift + F5.
For example, if you have a query containing two statements and your cursor is placed on the second statement:
When you press Shift + F5, only the second statement is executed:
You can also execute the current batch (ie code between two GO commands) by pressing Alt + Shift + F5.
You can also execute to the cursor by pressing Ctrl + Shift + F5. This executes from the start of the script to the cursor, including the statement under the cursor.
You can now use SQL Prompt to automatically insert missing semicolons after each statement in a query.
To insert semicolons, go to the SQL Prompt menu and click Insert Semicolons. Alternatively, hold Ctrl and press B then C.
When you place your cursor over a BEGIN or END keyword, SQL Prompt now automatically highlights the matching keyword:
When you're writing an INSERT statement, SQL Prompt now automatically highlights matching columns and data:
If you want to change the highlight color, you can use the Management Studio functionality for customizing colors.
In Management Studio, go to Tools > Options > Environment > Fonts and Colors and select a new color for Brace Matching (Rectangle):
Use object definition case
You can now use the object name's case for user-defined objects (tables, views, user-defined data types, etc) when applying casing options.
For example, if a data type named MyType is used in a script as mytype, when you format the script or apply casing options SQL Prompt will change the object's case to MyType.
To use object definition case, in the SQL Prompt options, go to Format > Case and select Use object definition case.
Rename variables and aliases
You can now use SQL Prompt to rename all occurrences of a variable or alias in a query.
To rename a variable or alias, place your cursor over an instance of the variable or alias you want to rename and press F2:
- Suggestions added for the following object types:
- Check constraints
- Message types
- XML schema collections
- Triggers in ALTER TABLE suggestions are now filtered by the table
- Columns in CREATE TABLE statement are suggested for PRIMARY and FOREIGN keys
- CLR methods are now suggested for hierarchyid, geometry and geography CLR types
- Suggestions from CREATE statements
- Suggestions added for FEDERATION related keywords on Azure
- Query hint option IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX is now suggested
- Improvements to snippet suggestions after aliases
- Improved support for table-valued variables and parameters
- Data types are now suggested if running in a disconnected query
- Suggestions improved for longer scripts
- Support for suggestions using default schema syntax (eg "master..sp_help")
Qualify object names improvements
The qualify object names feature now includes the following improvements:
- A new option for qualifying column names with aliases
- Changes to the script are now highlighted
- Errors are no longer displayed if temporary tables are created in the script
- The existing cache is now used rather than recaching some objects
- If the table has been aliased, table qualification is replaced with its alias
Remove square brackets
SQL Prompt can now automatically remove square brackets from a script.
To remove square brackets, go to the SQL Prompt menu and click Remove square brackets. Alternatively, hold Ctrl and press B then B.
Nullability of columns
SQL Prompt now displays the nullability of columns in the object definition box, tooltips and suggestions box:
Choose environments to install to
You can now choose to install SQL Prompt into Management Studio and/or Visual Studio:
New formatting options
- Align SELECT with INSERT
- Indent BEGIN...END blocks
New tab history options
- Maximum tab size
Tabs larger than the maximum size now won't be stored in the history. The default is maximum size is 1MB.
- Maximum number of tabs to restore
The default is 20.
Improved loading dialog box
The database loading dialog box now shows actual progress, and you can cancel loading databases:
Support for restricted accounts
You can now connect as:
- a user on contained database
In previous versions of SQL Prompt a "Login failed for user..." message was displayed.
- a restricted Azure user
- 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
- 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
Version 6.4.1 - December 2nd, 2014
Option added for global variables casing
Option added for automatically inserting column list on an OUTPUT - INTO clause
CURSORs can now be renamed (with F2) and will have their casing made consistent with declaration if "Use object definition case" is on
Column aliases are now suggested on ORDER BY clauses
Column aliases are now suggested from VALUES clauses on SELECT statements
Improvements to logic for inserting closing quotes and square brackets
Database names are now suggested from CREATE DATABASE statements in script
Snippet files are now stored as UTF-8 (instead of UTF-16) to support more diff/merge tool
- Fix for syntax error being reported on valid OUTPUT clause (Forum post)
- Fix for VALUES being inserted after OUTPUT INTO clause (Forum post)
- Fix for snippet indentation
- Wildcard expansion alignment improved when tabs are used as indents
- Fix for exception being thrown with expand wildcards
- Fix for index being incorrectly qualified with table name (Forum post)
- Fix for trigger not being qualified if table name is already qualified (Forum post)
- Fix for semicolon being inserted in wrong position (Forum post)
- Nullability of columns is now shown for variables of type TABLE
- INSERT column highlighting now highlights in both panes if window is split (UserVoice)
- Improved suggestions after a syntax error in script (Forum post)
- Fix for bug with Auto Refresh experimental feature causing initial cache to fail (Forum post)
- Fix for loading dialog box not being displayed (Forum post)
- Fix for duplicate semicolon being inserted after an INSERT with EXEC in it (Forum post)
- Fix for formatting ELSE with semicolon between it and the IF (Forum post)
- Fix for INSERT column highlighting with sub queries inside the SELECT query
- Fix for formatting ELSE statement with semicolons (Forum post)
- Fix for qualify object name using wrong alias if statement is invalid (Forum post)
- Fix for missing column suggestions on table valued function (Forum post)
- Fix for Prompt not providing suggestions on some queries in SSMS2008
- Fix for BEGIN/END indentation with stored procedures (Forum post)
- Fix for cursor jumping to the end of the line after completing a suggestion (Forum post)