SQL Prompt Pro v9.4.6

Automatically fix BP022 issues in your script.
December 17, 2018
New Version

Features

  • You can automatically fix BP022 issues in your script (it replaces the usage of the MONEY or SMALLMONEY datatype with the Decimal(19, 4) datatype).
  • "Check for Updates" renders as a popup in the bottom right rather than as a big modal.
    • User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely.

Fixes

  • SP-6956 : PE017 correctly considers the following functions as built-in system ones:
    • CONCAT
    • CONCAT_WD
    • FORMAT
    • TRANSLATE
    • TRIM
    • DATEFROMPARTS
  • SP-7366 : Fixed crash in 'Insert semicolons' that could occur when running formatting.
  • SP-7367 : Fixed issue with highlighting issues in list of issues with no script windows open sometimes throwing an error.
Automatically fix BP022 issues in your script.

SQL Prompt Pro

Intelligent code completion and layout for MS SQL Server.

Got a Question?

Live Chat with our Redgate Software licensing specialists now.