SQL Toolbelt Essentials v9.3

改進了 SQL 提示符內的格式設置操作。
9月 27, 2018
新版本

特性

New in SQL Prompt v9.3

  • You can now refactor INSERT statements into UPDATE statements, making it easier to update the data in your tables.
    • This can be triggered by either right clicking in the script window and selecting the command, or by using the keyboard shortcut Ctrl+B, Ctrl+P.
    • The refactoring automatically adds a default WHERE clause, which you can customize to suit your needs.
  • You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt.
    • Click SQL Prompt > Help > Product Learning to find how-to guides, in-depth technical articles and videos to help you uncover 'hidden gems' and make the most out of SQL Prompt.
  • SQL Prompt documentation now contains a list of all keyboard shortcuts available within the product.
  • When problems occur during formatting, the formatting actions that were successfully executed and those that were skipped are now displayed along with the failures.

修補程式

Fixed in SQL Prompt v9.3

  • SP-7208 : Fixed insert semicolon refactoring when merge statement was used as table source.
Refactor INSERT statements into UPDATE statements with SQL Prompt.

SQL Toolbelt Essentials

屢獲殊榮的各種工具,可進行資料庫的比較、生產效率、原始程式碼管理和故障排除。

有任何疑問嗎?

Live Chat現在與我們的Redgate Software 專家即時聊天詢問。