SQL Prompt 6.3 release notes
Published 20 March 2014
Version 6.3.0.343 - 8th April, 2014
Features
- Select in Object Explorer
For more information, see Selecting an object in the Object Explorer. - Many improvements to our SQL grammar
- UpperCamelCase and lowerCamelCase casing options
For more information, see Applying casing options. Highlighting matching parentheses
If your cursor is next to an opening or closing parenthesis in a query, SQL Prompt automatically highlights the matching parenthesis:
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):
- Template parameter dialog box now opens automatically if a snippet has parameters
For more information, see Using SSMS templates in SQL Prompt snippets. $SELECTIONSTART$and$SELECTIONEND$snippet placeholders
For more information, see Using placeholders.- 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 new SQL Server 2014 syntax
- Improvements to partial match suggestions
- Improved suggestion ordering (Forum post)
Suggestions box delay option added
- Pressing Enter after GO now enters a new line
- 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
- Properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc) are now suggested:
- Show schema names state is now saved
For instructions on how to view schema names in the suggestions box, see Displaying schema names.
Fixes
- Auto-completed functions won't insert closing parenthesis if directly before a column (eg
"SUM(Column"instead of"SUM()Column") - Column names on expand wildcard are no longer qualified with schema names
- Improved suggestions after errors in script (Forum post)
- Fix for "value" stopping suggestions (Forum post)
- Fix for suggestions stopping (Forum post)
- Fix for SP-4994 (Unable to load DLL 'SQLite.Interop.dll')
- Fix for SP-2947, SP-3598, SP-4984 (Very large encrypted stored procedures are not decrypted properly)
- Fix for "GO 10" crash (Forum post)
- Auto generated insert statements now use
GETDATE()instead of a string literal (UserVoice) - Fix for CamelCase datatypes enclosed in square brackets
- Fix for SP-5013 (NullReferenceException)
- A few missing suggestions added for built-in functions
- Auto generated insert statements with hints and a semicolon will keep the hints/semicolon (Forum post)
- Insert statements keep the table hints with the name when generating insert code (Forum post)
- Fix for keywords occasionally not being recased (Forum post)
- Fix for wrong suggestion being selected
- Fix for ‘left’ not being cased correctly (Forum post)
- Master database is enclosed with square brackets if the option is set
- Various keyword casing fixes
We've also fixed the following bugs that were send to us as error reports from SQL Prompt:
| SP-3532 | {SA} InvalidOperationException @ Scripter.ScriptFunction(…) |
| SP-3545 | {SA} FileLoadException @ BaseConnect.SetBindings(…) |
| SP-3556 | {SA} InvalidCastException @ VSEditorWindow.get_Selection(...) |
| SP-3591 | {SA} PathTooLongException @ SnippetManager.SaveSnippet(…) |
| SP-3594 | {SA} InvalidOperationException @ Scripter.ScriptView(…) |
| SP-3601 | {SA} InvalidOperationException @ Scripter.ScriptStoredProcedure(…) |
| SP-3659 | {SA} InvalidComObjectException @ BaseConnect.GetService(…) |
| SP-3680 | {SA} NullReferenceException @ EditorWindowBase.m_UIOptions_EnabledChanged(…) |
| SP-3687 | {SA} TargetInvocationException @ BaseForm.InitializeComponent(…) |
| SP-3735 | {SA} InvalidComObjectException @ SSMSEditorWindow.GetConnectionProperties(…) |
| SP-3738 | {SA} ObjectDisposedException @ DependenciesTreeView.Populate(…) |
| SP-3755 | {SA} ObjectDisposedException @ CandidateList2.UpdateSchemaNames(…) |
| SP-3756 | {SA} InvalidOperationException @ SqlPromptEngine.HoverPrompt(…) |
| SP-3771 | {SA} ObjectDisposedException @ ExpandableSchemaTooltipForm.ShowTooltip(…) |
| SP-3781 | {SA} ArgumentException @ ColoredLabel.ColoredLabel(…) |
| SP-3823 | {SA} IndexOutOfRangeException @ SqlPromptEngine.HoverPrompt(…) |
| SP-3860 | {SA} NotSupportedException @ LinkedDatabaseCandidate.GetPageReader(…) |
| SP-3865 | {SA} ObjectDisposedException @ CommandVSMenuItem.MenuCommand_ChangedStatus(…) |
| SP-3872 | {SA} ObjectDisposedException @ TooltipForm.MoveTooltipEvenIfHidden(…) |
| SP-3904 | {SA} ObjectDisposedException @ CandidateList2.HideCandidateList(…) |
| SP-3912 | {SA} InvalidOperationException @ DatabaseCandidateBase.GetConnectionSource(…) |
| SP-3987 | {SA} ObjectDisposedException @ Control.CreateHandle()(…) |
| SP-3996 | {SA} ObjectDisposedException @ ObjectDefinitionBox.HideSchemaInformationForm(…) |
| SP-3997 | {SA} ObjectDisposedException @ TaskExecuterForm.HideWindow(…) |
| SP-4063 | {SA} InvalidOperationException @ Client.Client(…) |
| SP-4099 | {SA} InvalidComObjectException @ EditorWindowBase.CheckConnectionChanged(…) |
| SP-4104 | {SA} TargetInvocationException @ EditorWindowBase.CheckConnectionChanged(…) |
| SP-4118 | {SA} AccessViolationException @ EditorWindowBase.CheckConnectionChanged(…) |
| SP-4141 | {SA} ObjectDisposedException @ EditorWindowBase/ParameterPromptTooltipForm.ShowTooltip(…) |
| SP-4161 | {SA} COMException @ Connect.GetEditorContextMenuBars(…) |
| SP-4169 | {SA} AccessViolationException @ Connect.GetEditorContextMenuBars(…) |
| SP-4183 | {SA} COMException @ VSCommandController.CreateCommand(…) |
| SP-4192 | {SA} InvalidComObjectException @ VSEditorWindow.GetWindowFrame(…) |
| SP-4258 | {SA} Exception @ Class702.smethod_5(SqlConnection sqlConnection_0)(…) |
| SP-4264 | {SA} ArgumentException @ ObjectFactory.LoadIndexes(…) |
| SP-4360 | {SA} InvalidComObjectException @ BaseConnect/<>c__DisplayClass8.<.ctor>b__6(…) |
| SP-4379 | {SA} InvalidComObjectException @ DteConnection.Dispose(...) |
| SP-4388 | {SA} NullReferenceException @ CandidateList2.EnableDisableFilters(…) |
| SP-4430 | {SA} TargetInvocationException @ RuntimeMethodHandle._InvokeMethodFast(...) |
| SP-4500 | {SA} ObjectDisposedException @ Connect.<GetEditorContextMenuBars>b__0(…) |
| SP-4512 | {SA} ObjectDisposedException @ ExpandableSchemaTooltipForm.ShowTooltip(…) |
| SP-4572 | {SA} InvalidOperationException @ VSEditorView.GetLocationForPosition(…) |
| SP-4702 | {SA} ObjectDisposedException @ ObjectDefinitionBox.ShowSchemaInformationForm(…) |
| SP-4723 | {SA} ObjectDisposedException @ ObjectDefinitionBox.MoveSchemaInformationFormEvenIfHidden(…) |
| SP-4726 | {SA} InvalidOperationException @ IpnUtils.IpnUtils(…) |
| SP-4751 | {SA} ObjectDisposedException @ TooltipForm.MoveTooltipEvenIfHidden(…) |
| SP-4781 | {SA} ArgumentException @ RecentlyClosedTabsCommand.RecentlyClosedTabsCommand(…) |
| SP-4807 | {SA} InvalidComObjectException @ VSEditorWindowBase.GetWindowFrame(…) |
| SP-4818 | {SA} ObjectDisposedException @ ToolWindow`1.get_DTEWindows(…) |
| SP-4848 | {SA} NullReferenceException @ CandidateCollectionMultiType`1.Add(…) |
| SP-4856 | {SA} InvalidComObjectException @ VSEditorWindow.ReplaceText(…) |
| SP-4918 | {SA} ObjectDisposedException @ ScriptPanel.HandleScript(…) |
| SP-4939 | {SA} NullReferenceException @ EditorWindowBase/<>c__DisplayClass25.<HoverPromptInfoReady>b__23(…) |
| SP-4945 | {SA} ObjectDisposedException @ Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)(…) |
| SP-4948 | {SA} InvalidOperationException @ DatabaseCandidateBase.SetDefaultSchema(…) |
| SP-4986 | {SA} ObjectDisposedException @ CandidateListBox.GetCurrentItemY(…) |
| SP-5003 | {SA} FileNotFoundException @ PromptEngineEmulator.get_GetSuggestions(…) |
| SP-5006 | {SA} MissingFieldException @ ReflectionUtils.GetFieldInfo(…) |
| SP-5008 | {SA} NullReferenceException @ RefactorEngine/<>c__DisplayClass9.<GetRecaseKeywordsRefactoring>b__8(…) |
| SP-5009 | {SA} IndexOutOfRangeException @ PrefixRadixTreeDictionary`1/TrieNode.Match(…) |
| SP-5011 | {SA} NotSupportedException @ LiveSchemaProvider.GetHobtSchema(…) |
| SP-5017 | {SA} InvalidStateException @ DBObjectSelectionManager.GetConnectionProperties(…) |
| SP-5018 | {SA} NullReferenceException @ LinkedDatabaseCandidate.GetDataTypes(…) |
| SP-5019 | {SA} MismatchedTokenException @ Parser.match(…) |
| SP-5020 | {SA} NullReferenceException @ TreeNodeExtensionMethods.EnumerateChildrenSynchronously(…) |
| SP-5073 | {SA} ArgumentOutOfRangeException @ SqlPromptEngine.GetCandidates(…) |
| SP-5074 | {SA} FormatException @ OptionsBase.Deserialize(…) |
