SQL Prompt Pro v9.3

이제 INSERT문을 UPDATE문으로 리팩터링합니다.
9월 27, 2018
신규 버전

기능

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

수정사항

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

SQL Prompt Pro

MS SQL Server를 위한 지능적인 코드 완성 및 레이아웃.

SQL Prompt Pro 도 구매할 수 있습니다:

궁금한 점이 있으세요?

Redgate Software 사 제품 라이선스 담당자와 라이브 채팅