These pages cover SQL Prompt 7, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

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

 


  • No labels