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.
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.
Easily opens recently closed tabs within one SSMS session, including the unsaved ones.
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.
With the multi scripts feature, you can 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.
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.
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.
A handy feature allowing you to execute a script to the current position of the cursor.
Navigate from Code Editor straight to a specific object in Object Explorer (Server Explorer in Visual Studio).
dbForge SQL Complete easily handles encrypted objects, it shows the DDL of an encrypted object in a separate SQL document.
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.
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.
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.
Discover matching BEGIN CATCH/END CATCH pairs in complex queries. After clicking one of the statements, the syntax pair will be highlighted.
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.
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.
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.
Find matching BEGIN/END pairs in complex queries. By pressing SHIFT+F12, your cursor will jump up or down to the matching keywords.
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.
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.
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.
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.
Managing and troubleshooting the flow of SQL code can be quite backbreaking, however, with SQL Complete, you can jump between the GOTO statements and labels they are targeted to in a wink of an eye.
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.
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.
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.
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.
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.
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.
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.