Released: Nov 26, 2024

10.15.3.12768 での更新項目

不具合の修正

• Fixed an issue where multiple instances of the same query tab opened by SQL History in SSMS.

Released: Nov 25, 2024

10.15.2.12691 での更新項目

不具合の修正

• Fixed SQL Prompt (15.1) that caused an error to appear while opening in Visual Studio.

Released: Nov 19, 2024

10.15.1.12422 での更新項目

機能

• Updated the licensing client.

不具合の修正

• Now allows tool to be used across user profiles on the same machine.
• Now prioritizes licenses correctly.
• Fixed an issue where SQL Prompt does not handle IGNORE NULLS on Azure SQL database.
• Fixed an issue where SQL prompt does not handle DATETRUNC on Azure SQL DB.

Released: Nov 13, 2024

10.15.0.12121 での更新項目

機能

• Updated licensing with improved UI, integration, security, and trials.
• Serial keys have been retired.
• Added the ability to show the aggregate values of a selection of cells in the results grid.

不具合の修正

• Fixed SQL Prompt not inserting selected suggestion when writing EXEC statement.

Released: Oct 3, 2024

10.14.23.11448 での更新項目

不具合の修正

• Fixed an issue where SQL Prompt+ would fail to log in.

Released: Sep 18, 2024

10.14.22.11347 での更新項目

機能

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

不具合の修正

• 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 definition on the same...

Released: Jun 14, 2024

10.14.21.9884 での更新項目

機能

• Added support for Synapse Serverless SQL Pools.

不具合の修正

• 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

10.14.20.9646 での更新項目

機能

• Improved SQL Prompt+ performance.

不具合の修正

• Fixed some errors in SQL Prompt+.

Released: May 23, 2024

10.14.19.9311 での更新項目

不具合の修正

• 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

10.14.18.8999 での更新項目

機能

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

不具合の修正

• 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 behavior option is...