SQL Prompt 6.0 release notes
Published 01 August 2013
September 4th, 2013
SQL Prompt Standard edition has been retired with the release of SQL Prompt 6.0. All SQL Prompt features are now available in a single edition.
If you are using SQL Prompt Standard, please email sqldev.info@red-gate.com to discuss your upgrade options.
SQL Prompt 6.0 includes the following:
Tab history
SQL Prompt now keeps a history of query tabs you open in SQL Server Management Studio:
For more information, see Tab history.
Synonym support
Synonyms (including columns from a synonym’s base object) are now suggested.
CLR support
CLR functions and CLR stored procedures are now suggested.
XML functions support
XML functions are now suggested.
SQL Azure support
SQL Azure databases are now supported.
Custom snippets folder
You can now share snippets with other SQL Prompt users by using a shared snippets folder:
For more information, see Sharing snippets.
More snippet placeholders
You can now use $PASTE$, $DBNAME$ and $SERVER$ in SQL Prompt snippets. You can also specify a custom $DATE$ and $TIME$ format, eg $TIME(HH:mm:ss)$.
For more information, see Using placeholders.
Indent using tab characters
You can now customize SQL Prompt formatting to indent text using tab characters:
JOIN clause improvements
All relevant tables are now suggested in a join clause, and we’ve added an option to swap the order of columns in the clause:
Copy from object definition box
You can now press CTRL + C to copy the contents of the object definition box.
Bug fixes
We've fixed the following bugs that were reported by users:
| SP-1057 | Select from table WH does not suggest WHERE |
| SP-1170 | XML value predicate doesn't work |
| SP-1329, SP-1871, SP-3060, SP-3090, SP-3612 | Use tabs instead of spaces while laying out |
| SP-2129 | Ctrl + C does not copy in hover prompt expanded schema panel |
| SP-2381 | SM#78 FOR XML statement squigglied |
| SP-2571, SP-2731 | Ctrl + A doesn't work in the snippet editor |
| SP-2804 | Once trial has expired, it says you still have an 'unlicensed trial' |
| SP-2914 | (XML) value statement is autom. converted to uppercase |
| SP-2947 | Code of a procedure is shown twice when using the copy code for a stored procedure |
| SP-3136 | SET @xml_variable.modify(...) is not recognized |
| SP-3928 | No candidates in the list for FETCH NEXT ... INTO |
| SP-4236 | Middle-click closes the in focus tab, not the tab that the mouse cursor is over |
| SP-4454 | Find invalid objects fails with an incorrect error on this attached DB |
| SP-4495 | SQL Prompt doesn't install into Visual Studio when SSMS is also installed |
| SP-4546 | Native intellisense is not suppressed in SSMS 2012 |
| SP-4547 | {SA} TypeLoadException @ UnusedVariableMarker.FromAnalysisResult(…) |
| SP-4576 | Suggestions stop in query window after XML query |
| SP-4577 | Attempting to format a query with a question mark hangs SSMS |
| SP-4628 | Prompting and tooltips offset when using a non standard dpi (Medium or High settings) in SSMS 2012 (F0069016) |
| SP-4711 | Support try_cast 2012 function in format SQL |
| SP-4745 | Support continuous connection to server in VS 2012 |
We've also fixed the following bugs that were send to us as error reports from SQL Prompt:
SP-3412 | {SA} NullReferenceException @ PromptEngineEmulator.ApplyCompletionFor(...) |
SP-3912 | {SA} InvalidOperationException @ DatabaseCandidateBase.GetConnectionSource(…) |
SP-4001 | {SA} NullReferenceException @ UpdateUtils.StartupUpdate(…) |
SP-4124 | {SA} InvalidProgramException @ EditorWindowBase.OnSqlPromptEnabledChanged(…) |
SP-4127 | {SA} InvalidProgramException @ VSScriptProvider.NotifyScriptChange(…) |
SP-4257 | {SA} FileNotFoundException @ ColumnDependenciesCalculator.RegisterDabase(…) |
SP-4267 | {SA} NullReferenceException @ ObjectExplorer.UnHookEvents(…) |
SP-4269 | {SA} ArgumentOutOfRangeException @ PrefixRadixTreeDictionary`1/TrieNode/<FindPartial>d__2e.MoveNext(…) - Calculating suggestions during database load |
SP-4293 | {SA} ArgumentNullException @ ServerTools.GetServerName(…) |
SP-4346 | {SA} NullReferenceException @ ServerTools.CreateTabNameToServerNameDictionary(…) |
SP-4359 | {SA} ArgumentNullException @ AddinServices.GetServiceForSite(…) |
SP-4413 | {SA} NullReferenceException @ PromptEngineEmulator.get_FilterStartIndex(…) |
SP-4547 | {SA} TypeLoadException @ UnusedVariableMarker.FromAnalysisResult(…) |
SP-4561 | {SA} NullReferenceException @ DatabaseCandidateBase.GetAllColumns(…) |
SP-4568 | {SA} NullReferenceException @ PromptEngineEmulator.get_FilterStartIndex(…) |
SP-4703 | Exception occurs when using middle click on the mouse to close a tab that was not active when Coloured Tabs active |
SP-4704 | {SA} NullReferenceException @ Connect2010.Dispose(…) |
SP-4706 | {SA} NullReferenceException @ UnhandledExceptionHandler.UnhandledExceptionHandler(…) |
SP-4735 | {SA} ArgumentOutOfRangeException @ StrongName.StrongName(…) |
SP-4779 | {SA} InvalidProgramException @ Options.ToString(…) |
SP-4785 | {SA} InvalidProgramException @ StandardEditionCommonControl.set_Label(…) |
SP-4792 | {SA} SqlException @ SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)(…) |
SP-4802 | {SA} FileNotFoundException @ TableSplitWizard.BWRegisterDabase(…) |
We’ve also fixed some stability issues on Windows 8 and 8.1.
