Lanzamientos de SQL Prompt Pro

Released: May 9, 2024

Actualizaciones en 10.14.18.8999

Características

  • You can now allow the "Enable Code Analysis" option to be set separately for Microsoft SQL Server Management Studio (SSMS) and Visual Studio.

Correcciones

  • Fixed an issue where Prompt+ AI could lose focus.
  • Fixed an issue where SQL Prompt was failing to format query with ALTER DATABASE MODIFY statement.
  • Fixed an issue with the product installer resetting language settings in VS 2022.
  • Fixed an issue with multiline comment formatting consistency when the "Tabs where possible" tab...

Released: Apr 30, 2024

Actualizaciones en 10.14.16.8679

Características

  • Added a multiline comment formatting option for recognizing common comment patterns.

Correcciones

  • Fixed an issue with multiline comments not respecting "tab behavior".

Released: Apr 19, 2024

Actualizaciones en 10.14.15.8425

Correcciones

  • Fixed an issue where Prompt+ AI Assistant could cause SSMS to crash.

Released: Apr 15, 2024

Actualizaciones en 10.14.14.8187

Correcciones

  • Fixed an issue where Prompt+ AI Assistant would cause a crash in SSMS 19.

Released: Apr 11, 2024

Actualizaciones en 10.14.13.8134

Características

  • Added syntax for TRIM with LEADING, TRAILING, or BOTH options to Azure SQL Databases.

Correcciones

  • Fixed an issue where some parameters for DBCC CLONEDATABASE were missing in suggestions.
  • Fixed an issue where some properties for DATABASEPROPERTYEX were missing in suggestions.

Released: Apr 2, 2024

Actualizaciones en 10.14.12.7945

Correcciones

  • Fixed an issue with SSMS 20 prompting TextMgrP.dll error upon launch.

Released: Mar 28, 2024

Actualizaciones en 10.14.11.7894

Características

  • Added support for Microsoft SQL Server Management Studio (SSMS) 20.

Released: Mar 14, 2024

Actualizaciones en 10.14.10.7538

Correcciones

  • 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.

Released: Feb 29, 2024

Actualizaciones en 10.14.9.7331

Características

  • 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.

Correcciones

  • Fixed an issue where casing wouldn't be applied to a built-in function after cross applying a statement with a user defined XML function.
  • Fixed an issue where "Qualify Object Names" would add incorrect qualifier for temporary table columns in the FOR UPDATE OF clause.

Released: Feb 8, 2024

Actualizaciones en 10.14.8.6563

Características

  • Added suggestions in LAG, LEAD and formatting in LAG, LEAD, FIRST/LAST_VALUE for RESPECT/IGNORE NULLS.