Helps you easily define the server connection a tab is currently related to by the matching color.
With this functionality, you can simply assign a color to the environment for the servers related to development, production,
sandbox or test. Additionally, it is possible to add or delete Color Match by clicking the corresponding buttons on the Settings
section of the Options menu.
The functionality monitors active open sessions, thus, allowing you to restore accidentally closed or unsaved tabs within the current IDE session.
Custom SSMS main window title
You can change or define your own naming pattern for the SSMS main window caption and SQL document tabs.
This way a proportional tab width is achieved so that you can control what is displayed in the tab name.
Restore last closed tab
Easily opens recently closed tabs within one SSMS session, including the unsaved ones.
Close unmodified tabs
The functionality closes the tabs that were not modified during your current MSSMS session.
Stores main information about executed SQL statements for a particular period.
You can view, edit, and search the queries you run in the database.
Additionally, you can monitor who executed a query and when, as well as other valuable information.
Run script on multiple databases
Select databases on the current server and execute a script against them from one query window.
You can also specify the mode, in which the script will be executed for the selected databases: parallel or sequential.
Document Outline window
It displays a current document structure and considerably simplifies navigation in large SQL documents.
You can synchronize the structure with text directly from the code.
Execute current statement
You can execute a specific SQL statement without selecting it. You just need to place the mouse pointer over the statement
and press Ctrl+Shift+E or Alt+Enter, and dbForge SQL Complete will define the statement boundaries itself.
Execute to cursor
A handy feature allowing you to execute a script to the current position of the cursor.
Go to definition for database objects
Navigate from Code Editor straight to a specific object in Object Explorer (Server Explorer in Visual Studio).
Decrypt encrypted objects
dbForge SQL Complete easily handles encrypted objects, it shows the DDL of an encrypted object in a separate SQL document.
Highlight occurrences of identifiers
If you click an identifier in your code, SQL Complete will highlight all other occurrences of this identifier within your statement with grey color. The feature helps quickly discover where the current identifier is used.
Highlight BEGIN and END
If you click a BEGIN or END delimiter in your code, SQL Complete will highlight the BEGIN/END syntax pair in your statement with grey color. The feature helps quickly find matching BEGIN and END statements in a query.
Highlight BEGIN TRY/END TRY
The matching BEGIN TRY/END TRY statements will be highlighted with grey color after you click one of them. The feature significantly facilitates coding by helping quickly find matching statements in long and complex queries.
Highlight BEGIN CATCH/END CATCH
Discover matching BEGIN CATCH/END CATCH pairs in complex queries. After clicking one of the statements, the syntax pair will be highlighted.
Highlight CASE and END
Highlighting matching CASE and END operators can significantly reduce your coding time as CASE expressions used in SQL syntax can be quite long and navigating through them is not an easy task.
Highlight COLUMNS and VALUES in INSERT statement
SQL Complete highlights the name of the columns and its corresponding value in the INSERT statements to help you insert valid values. The feature significantly facilitates writing queries to insert values into multiple columns.
Navigation between queries
When you work with large scripts, SQL Complete will help you quickly find the beginning of an SQL statement.
Just press a certain hotkey combination and the cursor will sequentially jump to the beginning of each statement in the SQL document.
Navigation between BEGIN and END
Find matching BEGIN/END pairs in complex queries. By pressing SHIFT+F12, your cursor will jump up or down to the matching keywords.
Navigation between BEGIN TRY/END TRY
When working with large scripts, it is important to be able to quickly navigate between paired keywords in an SQL statement.
With SQL Complete you can jump between BEGIN TRY and END TRY in a blink.
Navigation between BEGIN CATCH/END CATCH
Find matching BEGIN CATCH/END CATCH pairs in complex queries. By pressing Shift+F12, your cursor will jump up or down to the matching keywords.
Navigation between CASE и END
The CASE expressions used in statements can be quite long and navigating between their beginnings and ends can be a daunting task.
To solve this problem, jumping between CASE and END has been introduced.
Navigation between brackets
You can quickly jump between matching brackets within a statement by pressing Ctrl+]. This SSMS built-in feature helps save time and energy when writing long and complex queries.
Navigation between COLUMNS and VALUES in INSERT statement
In large INSERT statements, it's often hard to determine which value corresponds to which column, and vice versa. This functionality will help you
quickly locate a corresponding value for the current column.
Generate CREATE/ALTER script for server objects
This option lets you generate a script for object's modification after you drag the carriage to that object.
Quickly generate CRUD (CREATE, READ, UPDATE, DELETE) stored procedures for tables using customizable procedure
that can be changed to better suit your needs.
Unwraps the sp_executesql procedure into a neat and readable static SQL query.
Convert EXEC to script
This feature allows to simplify debugging by replacing the call to a stored procedure with the stored procedure body.
It takes the contents of the stored procedure and replaces the call in your query with them.
Convert Inline EXEC to Script
Unwraps the sp_executesql procedure into a neat and readable static SQL query.
This feature analyzes potentially dangerous statements (DELETE, DROP, TRUNCATE, and UPDATE) and generates
a pop-up alert if a user is about to execute a statement that may cause data loss. For example, the execution
warning will be thrown up if you try to execute a DELETE statement with no WHERE clause.
When a query is successfully executed, a pop-up dialog box notifies you about the time of execution.
If the query was running more than 23:59:59 hours, days are added to the time in the Execution Notification.
Whenever there open transactions during query execution,
a reminder will pop-up informing you about the number of uncommitted transactions.
Generate Script As from SSMS data grid
You can generate a script from the SSMS grid based on the data in the table for the following statements: INSERT, INSERT #tmpTable,
WHERE IN(), WHERE AND OR, UPDATE. You can select the result statement to be saved to a file, copied to a clipboard, or opened in a new window.
Copy data from SSMS grid to file or clipboard
The data from a cell or entire table can be copied from the results grid to a file or clipboard in any of the available formats (CSV, XML, HTML, JSON).
Aggregates are automatically displayed at the bottom of the SSMS Results Grid. Select a range of values in the Results Grid to calculate aggregates.
On the Aggregate Panel, you will see MAX, MIN, AVG, SUM, COUNT, DISTINCT ON for these values. To copy a value from the Aggregate Panel,
double-click it or select it with a cursor and press Ctrl+C. Alternatively, double-click the value you want to copy and select the Copy command from the context menu that appears.
In the Results Grid, data in Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, Spatial formats may be visually represented via the Data Viewer window.
Data can also be conveniently saved as a file. For example, hex data shown in a grid can be saved as a JPEG image.
Find in Results Grid
Searches all the matching data in the grid by the specified value.
Extend the search by adding the following search details:
Match Case to set a case-sensitive search
Whole Words to look for the single words
Use Regular Expressions to set the search by Reg Exp
Close button to close the search bar
All the data found will be highlighted in the Results Grid.