Lanzamientos de SQL Prompt Pro

Released: Sep 18, 2024

Actualizaciones en 10.14.22.11347

Características

  • Added option for "Open in Excel" where numeric values longer than 15 digits will be saved as text to prevent Excel rounding.
  • Default values of Stored Procedure Parameters are now being displayed in suggestions.

Correcciones

  • Fixed renaming aliases whose name is the same as the object name.
  • Fixed an issue where SQL Prompt wouldn't highlight all matched objects in some queries.
  • Fixed DELETE statement formatting with TOP() filter.
  • Fixed an issue where formatting a CTE places the...

Released: Jun 14, 2024

Actualizaciones en 10.14.21.9884

Características

  • Added support for Synapse Serverless SQL Pools.

Correcciones

  • Fixed Prompt+ in SSMS 18.
  • Fixed few issues which caused data types to be missing/invalid for aliased columns.
  • Fixed Apply Column Alias Style with WINDOW OVER clause.
  • Fixed invalid data type of aliased columns when using arithmetic operators.

Released: Jun 5, 2024

Actualizaciones en 10.14.20.9646

Características

  • Improved SQL Prompt+ performance.

Correcciones

  • Fixed some errors in SQL Prompt+.

Released: May 23, 2024

Actualizaciones en 10.14.19.9311

Correcciones

  • Fixed an issue where Unformat refactoring would leave unnecessary space.
  • Fixed an issue where the SUSER_NAME() tooltip would show an incorrect return type.
  • Fixed detecting data type for columns created using OVER clause nested in CASE.
  • Fixed an issue where adding alias to the column with OVER clause could fail with error.

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.