SQL Prompt Bundle 7.3

SQLのフォーマット方法を改善
12月 5, 2016
新バージョン

機能

  • Improved SQL formatting - includes a new experimental version of the Format SQL feature, the formatting styles are now much more customizable.
  • Added more options for formatting CASE statements, JOINs, CTEs, CREATE TABLE statements, IN values, and more.
  • Easier to:
    • Create your own style by using one of the new built-in Redgate styles as a starting point.
    • Share your formatting styles with other SQL Prompt users by storing them in a shared folder.
    • Create multiple formatting styles and switch between them.
    • Disable SQL Prompt formatting for certain blocks of code.
  • Added ability to inline EXEC stored procedures and scalar functions in a query window (UserVoice).
  • Also added inline EXEC sp_executesql (UserVoice). This replaces the dynamic SQL with static SQL.
  • Choose to show execution warnings for:
    • Statements with an INNER JOIN (UserVoice)
    • Scripts that create or alter a procedure or trigger (UserVoice)
    • TRUNCATE statements
  • Format actions for aliases - includes two new format actions:
    • Add/remove AS keyword on alias definition for tables and views (UserVoice)
    • Apply column alias style (UserVoice)
  • OUTPUT parameter variables - Variables are now declared automatically for OUTPUT parameters when generating an EXEC statement (UserVoice).
  • Microsoft SQL Server 2016 syntax support - SQL Prompt now suggests and formats the following new SQL Server 2016 SP1 syntax:
    • CREATE OR ALTER (UserVoice)
    • DBCC CLONEDATABASE
    • USE HINT query hint
  • User account licensing - SQL Prompt now uses Redgate user account licensing, which makes it easier to keep track of the tools you own and move them between different machines.
  • Other improvements
    • Support for Microsoft Azure Active Directory Integrated authentication and Azure Active Directory Password authentication (UserVoice)
    • The scale and precision of a data type are now shown in tooltips and summary windows (UserVoice):
    • Improved suggestions when using GRANT with schemas (Forum post)
    • OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
    • Column names in temp tables using quoted identifiers are now suggested
    • DBCC SHOW_STATISTICS now displays options when passing in string arguments (UserVoice)
    • Script as INSERT now outputs rowversion/timestamp columns as varbinary
    • Experimental feature added to refresh the SSMS IntelliSense (UserVoice)

不具合の修正

  • Find Invalid Objects now reports objects as invalid if a connection to a linked server fails (Forum post).
  • Fix for an undocked query window losing focus in SSMS2016 and VS2015 (Forum post).
  • Fix for square brackets being incorrectly added around NO_INFOMSGS (Forum post).
  • Fix for execute current statement not selecting the whole ALTER TABLE statement (Forum post).
  • Fix for incorrectly qualifying a column using the xml "modify" method (Forum post).
  • Fix for keyboard focus not changing when switching back to SSMS (Forum post).
  • 'd' is no longer used as a keyboard shortcut for deleting snippets in the snippet manager (UserVoice).
  • "go" is no longer used as an auto-generated alias name (UserVoice).
  • Alt+Shift+F5 is now the keyboard shortcut for "execute current batch" in SSMS2016 and VS2015.
  • Ctrl+Shift+F5 is now the keyboard shortcut for "execute to cursor" in SSMS2016 and VS2015.
  • Support ticket 70098: Fix for connection timeout settings not always being respected.
  • Support ticket 68772: Fix for incorrect suggestion when an alias name is defined as a unicode string literal.
  • Support ticket 77352: Fix for incorrect precision being displayed on tooltip for DATETIME2 data types.
  • Support ticket 76234: Fix for incorrect column dependency being displayed.
  • Support ticket 75896: Fix for incorrect column being used when expanding wildcard.
  • Support ticket 76423: ambiguous columns are now always qualified with their table/alias inside an ORDER BY clause.
  • Support ticket 74368: Fix for a semicolon being incorrectly added on an ALTER table statement with a masked column.
  • Support ticket 73072: Fix for cancel button not responding when using Open in Excel.
  • Support ticket 72842: Fix for visual glitch when using keyboard navigation on execution warning dialog.
  • Support ticket 70681: Open in Excel exports Date data types without a time.
SQL Prompt Bundle 7.3
SQL Prompt Bundle

SQL Prompt Bundle（英語版）

Microsoft SQL ServerのエディターにIntelliSense機能を追加

見積もりの依頼 購入

ご質問がありますか？

今すぐ Redgate Software ライセンススペシャリストとライブ チャット。