SQL Prompt Pro（英語版）

リリースノート: Fixed an issue where Prompt+ AI Assistant would cause a crash in SSMS 19. 0 ...

リリースノート: Added syntax for TRIM with LEADING, TRAILING, or BOTH options to Azure SQL Databases. Fixed an issue where some parameters for DBCC CLONEDATABASE were missing in suggestions. Fixed an issue where some properties for DATABASEPROPERTYEX were missing in ...

リリースノート: Fixed an issue with SSMS 20 prompting TextMgrP.dll error upon launch. 0 ...

リリースノート: Added support for Microsoft SQL Server Management Studio (SSMS) 20. 0 ...

リリースノート: Fixed exporting results to Microsoft Excel format. Fixed "Could not load file or assembly System.Memory" exception, occurring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip. 0 ...

リリースノート: Add refactoring for converting sp_executesql expressions to SQL. Added formatting for EXTERNAL TABLE, EXTERNAL DATA SOURCE, EXTERNAL FILE FORMAT. Added formatting for WINDOW clause. Fixed an issue where casing wouldn't be applied to a built-in ...

リリースノート: Added suggestions in LAG, LEAD and formatting in LAG, LEAD, FIRST/LAST_VALUE for RESPECT/IGNORE NULLS. 0 ...

リリースノート: Fixed an issue where FOR item in PIVOT clause would not collapse properly when collapse if short parentheses option was set. Fixed an issue where create script preview for table wouldn't show data types precision if default value was used. 0 ...

リリースノート: Added intellisense support to EXTENDED EVENTS syntax. Fixed an issue where formatting query with RESTORE statement wouldn't properly format URL clause. Fixed an issue which caused single-line comments to occasionally not align. Fixed an issue where ...

リリースノート: Added the option to disable formatting for groups of single-line comments. Fixed formatting for multiline comments. Fixed an issue where code formatter crashed with double angle brackets present in a script. Fixed an issue where new lines would be added ...

リリースノート: Fixed an issue where Pre/Post script window in SQL Source Control would cause SQL History to crash. Fixed missing newline before INTERSECT and EXCEPT operators. Fixed an issue where unformatting would add unnecessary spaces. 0 ...

リリースノート: Fixed an issue where formatting wouldn't move UNION clause to a new line when it was used after INTO clause. Fixed an issue where the F12 shortcut was unavailable in Microsoft Visual Studio. The keyboard shortcut for "Script Object as ALTER

リリースノート: Fixed an issue where SQL Prompt crashed Microsoft SQL Server Management Studio (SSMS) 18. 0 ...

リリースノート: Fixed an issue where formatting scripts with a CASE clause would occasionally cause an error. 0 ...

リリースノート: Added Prompt+ AI as a preview feature. Fixed an issue where formatting query with URL keyword would cause parsing errors. Fixed an issue where UNION clause dealigned INTO item during formatting with Align Items Across clauses turned on. Fixed an issue ...

リリースノート: v10.13.16.3650 Updated Oct 26, 2023 Fixes Fixed an issue where tabs would not restore when connection was of Active Directory Password type. Fixed connecting to Azure via Azure Active Directory Password in SSMS 18. Fixed an issue where comments would not ...

リリースノート: v10.12.6.30951 Updated Oct 20, 2022 Fixes Fixed Azure MFA connections for SSMS 19 Preview 3. Fixed an issue with renaming tabs in Tab History. Altered Export to Excel to treat numeric values as numbers in Excel. v10.12.5.30313 Updated Sep 28, 2022 Fixes ...

リリースノート: Adds command palette which provides a fast way to navigate SQL Prompt and SSMS via a single keyboard shortcut. v10.11.12.27800 Updated May 16, 2022 Fixes Fixed an issue when applying autofixes in bulk. Fixed an issue where try_convert formatting could ...

リリースノート: v10.10.4.26165 Updated Jan 18, 2022 Features Improved detection when Replace Select Into With Create Table autofix is available. Added the ability to open SQL Dependency Tracker from the object definition window when viewing an object's dependencies. ...

リリースノート: v10.9.3.25270 Updated Nov 24, 2021 Features Added "no-layout" option to command line formatter. Improved suggestions for CREATE TABLE. Fixes Fixed an issue where 'Restore defaults' in the options menu could require multiple attempts to ...