dbForge SQL Complete for SQL Server receives improvements on an ongoing basis. To stay up to date with the most recent developments, this article provides you with information about:
- New features
- Ongoing updates
- Bug fixes
This topic includes release notes for version 5.8.
Code Completion Features
- ALTER MESSAGE TYPE
- DROP MESSAGE TYPE
- Prompt extension in SQLCMD Mode
- Display a list of CHECK and DEFAULT constraints
- Unwrap sp_executesql
- OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
- XML methods suggestion XQuery
- CREATE TYPE .. AS TABLE
- CREATE TYPE .. FROM
- SET DATEFORMAT
- SEND ON CONVERSATION
- CREATE QUEUE
- CREATE AGGREGATE
- CREATE ASSEMBLY FROM
- DBCC CLONEDATABASE
Productivity Features
Jump between BEGIN/END
Navigation through the whole block on matching keywords of the BEGIN/END statements. To use this command, right-click either BEGIN or END, and select Jump Between Syntax Pairs on the shortcut menu. The matching pair will be highlighted. Note: you can also use shortcut keys Shift+F12.
Jump between COLUMNS and VALUES in INSERT statement
It helps you easily find a corresponding value of the specified column in INSERT statements. The command will highlight the matching column and value. Additionally, you can use shortcut keys Shift+F12 as in the Jump between BEGIN/ENDcommand.
Execution warnings
It shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE. Warnings are not shown when modifying temporary tables or temporary variables. Checkboxes are set for any environment of TRUNCATE, DELETE and UPDATE statements.
CRUD generator
Generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document. On the CRUD tab of the Options menu, you can select what statements to be included into the script and in what order the columns should be set.
Run script on multiple databases
Executes a script to a new SQL document on the selected database on the connection you choose. The connection of the document you use is selected by default. To use this functionality, right-click on the SQL document and select Execute On Multiple Targets…
Execution notifications
When the query execution is completed, a notification with such details as a name of the document and duration is displayed. In addition, you can enable a notification and specify execution duration on the Notifications tab of the Options menu.
Transaction reminder
The notification alerts users that a transaction has not been completed if you execute a script by clicking F5 in SSMS. It contains the document name and a number of open transactions. On the Options menu, notifications for transaction reminder are selected by default. Additionally, you can set duration on the menu.
Find in Results Grid
Searches the required data by highlighting all the matches either by case, or whole words, or regular expressions in the results grid. In addition, you can navigate through the grid by clicking arrow keys on the Find menu.
Copy Results Grid Headers
Make a copy of the selected column names and/or types to CSV, XML, HTML, and JSON data formats.
Grid Aggregates
Selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar. Clicking the Close button on the grid, clearing highlights from rows, and selecting one or several rows in different columns will close the aggregate grid.
Named Regions
Allows users to parse named and unnamed regions automatically, as well as wrap and unwrap regions.
Find Invalid Objects
Allows users to search invalid objects in the selected database.
You can find invalid objects by right-clicking a database or connection in the Object Explorer and navigating to SQL Complete – Find Invalid Objects.
Formatting Profile Quick Select
Allows users to quickly switch between active formatting profiles, as well as edit profiles by opening the Formatting Profiles window.
To use this feature, simply right-click anywhere on the SQL document and select Active Format Profile.
Other improvements
Fixes and improvements to Documents Sessions
