SQL Prompt Pro（英語版）

MS SQL Server開発向けの優れたコード補完機能とレイアウト

Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。

価格:¥ 44,000 (税込)〜 バージョン: 11.x 新機能 更新日: Apr 28, 2026 レビューの平均スコア： 5.00レビューの平均スコア： 5.00レビューの平均スコア： 5.00レビューの平均スコア： 5.00レビューの平均スコア： 5.00 (4)

SQL Prompt Pro（英語版） のスクリーンショット

SQL Prompt Pro のリリース

Released: Dec 3, 2020

10.5.x での更新項目

v10.5.6.17542

Updated Jan 22, 2021

Features

  • Added support for database scoped credentials in Microsoft SQL Server 2016 and later.
  • Added support for altering create index statements when using the alter view autocompletion.
  • Microsoft Azure Multi-Factor Authentication connections no longer require a second login for SQL Prompt.

Fixes

  • Fixed an issue which could cause the Insert Semicolons refactoring step to fail when creating Columnstore indexes.
  • Fixed an issue where the live preview does not...
続きを読む

Released: Sep 16, 2020

10.4.x での更新項目

v10.4.7

Updated Nov 9, 2020

Features

  • General performance improvements.

v10.4.6

Updated Oct 26, 2020

Fixes

  • Fixed Smart Rename and Split Table for connections using TrustServerCertificate.

v10.4.5

Updated Oct 15, 2020

Fixes

  • Fixed a crash on startup in Microsoft Visual Studio.

v10.4.4

Updated Oct 15, 2020

Features

  • Added support for Smart Rename and Split Table for Microsoft Azure MFA connections.

Fixes

  • Fixed script being misinterpreted when AT TIME ZONE was used with a variable.
  • Fixed an...
続きを読む

Released: Jul 2, 2020

10.3.x での更新項目

v10.3.9

Updated Sep 7, 2020

Fixes

  • Fixed an issue where the template parameters window appears after auto-completing a snippet containing XML.
  • Fixed an issue where the refactor insert into update operation failed when using certain SQL scripts.

v10.3.8

Updated Aug 28, 2020

Fixes

  • Internal improvements on SQL Prompt Tab History functionality.

v10.3.7

Updated Aug 12, 2020

Fixes

  • Fix for crash on startup when using extensions with conflicting versions of the Serilog logging library.

v10.3.6

Updated...

続きを読む

Released: Jun 2, 2020

10.2.x での更新項目

10.2.1

Updated Jun 10, 2020

Fixes

  • Fixed an issue where default values for snippet placeholders were not being saved after being changed.

10.2.0

Updated Jun 2, 2020

Features

  • SQL Prompt no longer uses a vulnerable version of SQLite.

Fixes

  • Fixed an issue with tab reconnection in SSMS 18.5.

Released: Feb 19, 2020

10.1.x での更新項目

10.1.7

Updated May 11, 2020

Fixes

  • Fixed an error with loading tab history options with different locales.

10.1.6

Updated May 11, 2020

Features

  • NOTE: The keyboard shortcut for "Show Open Tabs" has been changed from Ctrl+Q to Ctrl+Shift+X.

Fixes

  • SP-7985 : SQL Prompt no longer attempt to qualify objects when they are already qualified.
  • Fixed an error where running inline exec on certain procedures would change behaviour.
  • Fixed an error where SQL Prompt would fail to parse certain QUERY_STORE...
続きを読む

Released: Nov 6, 2019

10.0.x での更新項目

10.0.11

Updated Feb 5, 2020

Features

  • Added suggestions support for new permission types in SQL Server 2019.

Fixes

  • Fixed an issue with columns sometimes not being qualified when qualifying object names.
  • Fixed an issue with some functionality not appearing for servers connected using Windows authentication.

10.0.10

Updated Jan 29, 2020

Fixes

  • Fixed an issue that caused SSMS to crash when connecting to an Azure server using Multi-Factor Authentication.

10.0.9

Updated Jan 28, 2020

Features

  • Added...
続きを読む

Released: Oct 28, 2019

9.5.23 での更新項目

不具合の修正

  • Fixed an issue which would sometimes cause the Tab History/Code Analysis UI to fail to load.

Released: Oct 24, 2019

9.5.22 での更新項目

機能

  • Enhanced Tab History *
    • You can now star the tabs you use most often, so they're easier to find and restore when you need them.
    • Tabs are now shown in time buckets, making them easier to search through.
  • Added support for the APPROX_COUNT_DISTINCT aggregate function, introduced in SQL Server 2019.
  • Added support for the index options RESUMABLE and MAX_DURATION in CREATE INDEX statements, introduced in SQL Server 2019.

 

* SQL Prompt keeps a history of query tabs you open in Management Studio...

続きを読む

Released: Oct 16, 2019

9.5.21 での更新項目

機能

  • Added a new ranked ordering option for suggestions.
  • Added suggestions support for ADD/DROP SENSITIVITY CLASSIFICATION syntax introduced in SQL Server 2019.
  • Added suggestions for COMPATIBILITY LEVEL values for all supported versions of SQL Server.

不具合の修正

  • Fixed scenario that could lead to corruption of Prompt Options during export to a zip archive.
  • Fixed an issue which would sometimes cause formatting to fail when applied to a script containing a PIVOT clause within an UPDATE statement.
  • Fixed...
続きを読む

Released: Oct 2, 2019

9.5.20 での更新項目

機能

  • Smart Rename and Split Table refactorings are now no longer supported for SQL Server 2000/2005.

不具合の修正

  • SP-7804 : Fixed an issue with suggesting synonyms when schema/database filtering is enabled.
  • SP-7824 : Fixed an issue which would cause the Qualify Object Names refactoring to sometimes generate incorrect SQL when used on an UPDATE statement.
  • SP-7825 : Fixed keyboard shortcut _(Ctrl+Shift+E)_ for the [code analysis issue details pane](
続きを読む