#What is sql prompt core windows#

#What is sql prompt core windows#

Fixed an issue when upgrading snippets when a snippet's shortcut matches a Windows reserved file name.ДЎ0.4 - Released on 15th February 2021 Fixes.Fixed an issue where the SQL Server Data Tools (SSDT) is required error would be shown inconsistently when installing SQL Prompt.Added support for storing snippets in subfolders inside the configured snippets directory.Added support for underscores within identifiers prefixed with $.Added support for graph search patterns when using merge statements.Added support for ALL and DISTINCT arguments when using some SQL aggregate functions.Fixed an issue where choosing a suggestion in a query window causes unnecessary disk activity.ДЎ0.8 - Released on 23rd February 2021 Features.

Fixed an issue where previous versions of visual studio without SSDT would block the installer.Fixed an issue where master database connection error may show incorrectly when connecting to Azure servers.Fixed an issue where snippets starting with certain characters did not load.Fixed an issue where the insert semicolons refactoring could fail when applied on a selection within a BEGIN END block.FixedВ anВ issueВ whereВ snippetВ shortcutsВ mayВ becomeВ caseВ sensitive.ДЎ0.9 - Released on 29th March 2021 Features.Fixed an issue where default snippets would not be added when selecting the add default snippets option.Fixed an issue with not recognizing template parameters with spaces in their names.Fixed an issue where formatting operations could take significant time to cancel.Fixed an issue where cancelling a format could break subsequent formatting operations.You can now auto-fix ST010В issues in your script.You can now auto-fix ST002В issues in your script.You can now auto-fix PE023В issues in your script.You can now auto-fix PE003В issues in your script.You can now auto-fix PE002В issues in your script.You can now auto-fix PE001В issues in your script.You can now auto-fix MI003В issues in your script.You can now auto-fix EI003В issues in your script.You can now auto-fix DEP021В issues in your script.You can now auto-fix BP023В issues in your script.

You can now auto-fix BP010В issues in your script.

You can now auto-fix BP009В issues in your script.

You can now auto-fix BP008В issues in your script.

You can now auto-fix BP004В issues in your script.

Added support for DROP IF EXISTS for Azure SQL Server.

Fixed an issue where SQL Prompt would sometimes look in the SQL Prompt 9 directory for snippets.ДЎ0.1 - Released on 21st April 2021 Features.

Fixed an issue where opening results in Excel would sometimes result in an error.

Fixed an issue where opening results in Excel would sometimes result in an error when NULL values are present in the results.

Fixed an issue where columns with a numeric datatype would always have NULL as the placeholder value when using the INSERT INTO autocompletion.

Fixed an issue where function names had square brackets added to them when formatting.

Improved the performance of tab reconnection.

Fixed an issue where columns with a numeric datatype in temporary tables would always have NULL as the placeholder value when using the INSERT INTO autocompletion.ДЎ0.0 - Released on 11th May 2021 Features.

Fixed an issue where SQL Prompt may crash when using views on linked servers.

Added support for CURRENT_TIMEZONE and CURRENT_TIMEZONE_ID in Azure SQL Managed Instance.

Added support for GREATEST AND LEAST for Azure SQL Database and Managed Instance.

Fixed a crash on startup in Visual Studio 20.ДЎ0.9 - Released on 18th May 2021 Features.

Changed the Summarize Script dialog to allow interaction with the SSMS window when open.

Fixed an issue where SQL Prompt would crash when opening the context menu of an editor window tab.ДЎ0.5 - Released on 7th June 2021 Features.Fixed an issue where an exception would be shown after multiple failed refactorings.Fixed an issue where the Quick Actions menu items did not perform the selected action.10.9 - Released on 20th July 2021 FeaturesДЄddedВ theВ abilityВ toВ duplicateВ aВ tabВ inВ SSMS.ДЎ0.0 - Released on 7th July 2021 FeaturesД¬hanged the way objects are qualified such that the default schema is chosen where multiple schemas match.ДЇixed the crash when using summarize scripts where the script is invalid.ДЇixed an issue where connections to multiple contained Azure SQL databases may prevent suggestions appearing.ДЇixed an issue where sys objects may not be suggested when connecting to Azure databases without access to the master database.ДЇixed a crash when opening suggestions containing the German eszett (Гџ) character.ДЇixedВ aВ crashВ whenВ autocompleting reserved words and tableВ variables.