sql - SQL Prompt Pro

Release Notes: 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 ...

Release Notes: Fixed an issue where Prompt+ AI Assistant could cause SSMS to crash. 0 ...

Release Notes: Fixed an issue where Prompt+ AI Assistant would cause a crash in SSMS 19. 0 ...

Release Notes: Added support for Microsoft SQL Server Management Studio (SSMS) 20. 0 ...

Release Notes: Fixed an issue with SSMS 20 prompting TextMgrP.dll error upon launch. 0 ...

Release Notes: 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 ...

Release Notes: 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 ...

Release Notes: Added suggestions in LAG, LEAD and formatting in LAG, LEAD, FIRST/LAST_VALUE for RESPECT/IGNORE NULLS. 0 ...

Release Notes: 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 ...

Release Notes: 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 indentation was missing after WHILE statement ...

Release Notes: 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 after comment instead of before one. Fixed an ...

Release Notes: 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 ...

Release Notes: Fixed an issue where SQL Prompt crashed Microsoft SQL Server Management Studio (SSMS) 18. 0 ...

Release Notes: 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" has been changed from F12 to Alt+Y for ...

Release Notes: Fixed an issue where formatting scripts with a CASE clause would occasionally cause an error. 0 ...

Release Notes: 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 where alias functionality was not working for ...

Release Notes: 2023 Fixes Fixed style override when saving SQL Prompt settings. Fixed an issue with SQL History ignoring numbers in search. Fixed an issue where single line comments were not properly formatted. Fixed ... 22, 2023 Features Added support for saving advanced search settings for SQL History. Added support for multiple syntaxes on Azure SQL databases. Fixes Fixed an issue with connecting via Azure Active ... Directory with MFA for SSMS19.1. Fixed AT TIME ZONE expressions recognition. Fixed formatting issue for TRIM in SQL Server 2022. Fixed "Could not load file or assembly ...

Description: Intelligent code completion and layout for MS SQL Server. SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code ... choices. Automatic script layout provides easy code readability- particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so ... you can make it perform exactly the way you want it to. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard. SQL Prompt Write SQL fast and accurately ...

Release Notes: as numbers in Excel. v10.12.5.30313 Updated Sep 28, 2022 Fixes Fixed an issue where the SQL Prompt View in the SQL Compare diff window was not working. Fixed an issue where Export to Excel was always using ... scripted. v10.12.3.28623 Updated Jul 29, 2022 Features Added support for some Microsoft SQL Server 2022 syntax, including LEDGER. Fixes Fixed an issue where BIGINT data types were being exported to Excel ... Fixed an issue where formatting could incorrectly remove whitespace when using double-dot identifier notation. v10.12.0.27933 Updated May 26, 2022 Features Added support for Microsoft SQL Server ...

Release Notes: 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 ... when running the Qualify Object Names action. v10.11.9.27382 Updated Mar 30, 2022 Fixes Fixed a crash introduced in v10.11.8. Note: If you have installed SQL Prompt v10.11.8, please uninstall ... that version before installing SQL Prompt v10.11.9. v10.11.8.27379 Updated Mar 30, 2022 Fixes Fixed an issue where autofixes could fail when applied in bulk from the code analysis light bulb. Fixed an issue ...