View Source

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):

SQL Prompt 7 > SQL Prompt 6.4 release notes > prompt change highlight color.png

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(…)