ApexSQL Complete 2017 – Screen shot tour

Main menu of ApexSQL Complete

ApexSQL Complete toolbar:

Options:

General

The automatic tab renaming option automatically names SQL query window based on their contents. This option searches for create, alter, insert, update, delete, exec, or truncate SQL statement in the SQL query and renames the SQL query tab using these key words, allowing you to more easily locate the window you are looking for.

The Display object tooltip after check box, displays a detailed description of each database identifier used in the SQL statement that is currently being edited, while hovering over the identifiers themselves

Here you can set when the hint-list will be shown, how objects in the hint-list will be sorted and how many items will be shown in the hint-list at once:

CRUD

Automatically create select, insert, update and delete stored procedures using Create CRUD procedures feature.

To create procedures, right click on a table or database in Object Explorer and from the context menu chose the Create CRUD procedures command:

This will generate code in a new query tab:

The CRUD feature is located under the CRUD tab of the Options dialog with four sub-tabs for each of CRUD procedure templates (Select, Insert, Update, Delete):

Inserts

To automatically insert the appropriate closing character, use the Closing characters section. ApexSQL Complete will add automatically created aliases to SQL tables and views if the Auto-generate aliases option is selected:

Hints

Here you can be specified which objects will be shown in the hint-list:

Aliases

Specify aliases for SQL Server objects on a server or database level. Aliases can be defined for all databases on all SQL Servers, all databases on a specific SQL Server, or just for a specific database:

Schema cache

The Schema cache is a list of objects that the add-in cached in order to show them in the hint list:

Snippets

Reuse SQL code fragments as snippets and insert context-specific values as needed:

Shortcuts

Define custom keyboard shortcuts for commands:

Executed queries

With this feature user, can manage executed queries, search its content and re-use them:

Log information about executed queries:

Execution alerts

This feature analyzes SQL code, that is about to be executed, against a defined set of rules with the ability to block query execution and produce a warning message, in which the user has the option to Proceed or Cancel, in which case the script will either be executed or the execution will be aborted, respectively:

Execution alerts are located under the Execution alerts tab of the Options dialog:

Tab navigation

With Tab navigation user, can organize and save opened tabs, explore closed tabs and re-use them:

Keep track of opened and recently closed tabs:

Tab coloring

This feature will colorize query tabs by server or database connection.

Edit existing or set a new environment:

View the object’s definition and description inline:

Code structure

Identify the structure of complex SQL queries at a glance

Auto-replacement

The Auto-replacement feature allows you to replace any text previously specified with the appropriate keyword:

Go to object

To perform a quick object search over a database in order to find SQL Server database objects and get the appropriate information (e.g. how many tables have the same name in the database with different schemas) or to locate objects in the Object Explorer pane in SSMS, the Go to object feature can be very useful:

Copy results as

The Copy query as XML, CSV, and HTML option allows users to copy the results from the SSMS results grid and paste it into one of three mentioned formats. With the Copy result as Insert statement option, a user can copy data from Results grid into clipboard as INSERT statements for the future use. Copy result as an In clause you can copy data from one or more fields in the column into the clipboard as IN clause:

Results search

This feature searches through the data in the Results grid. All found data in the Results grid will be highlighted:

Export to Excel

The Export to Excel feature is used to export results from the Results grid to Excel.

To export data from the Result grid to an Excel file, select the desired data from the Result grid, right click and from the context menu choose Export to Excel option:

 

April 3, 2017
  • Ricardo Leka Roveri

    Hi, I love the Complete, but it´s possible add a cosmetic feature like a dark theme?

    • Marko

      Hi Ricardo,

      Yes, we have in plan to add a dark theme (GUI themes) in ApexSQL Complete R6, which will be released in May-June 2017.

      More information can be found here: https://www.apexsql.com/whats_next.aspx

  • Tomas HomeCat

    last version doesnt work on ssms 2016. when typing table name – hints-list doesnt reflect it and list remains with full set of tables, so i need to find table manually. selecting columns at this time also doesnt work.
    Thanks! https://uploads.disquscdn.com/images/77fe8c9d6c33c784c7fac72480f033e7ff5f9ba7f1c488bff0c77274231f7bc5.png

    • Marko

      Hi Tomas,

      Thank you for reporting this. This is unexpected
      behavior.

      Could you please send an email to support@apexsql.com
      with exact steps that led to the problem.

      Also, please send us the log
      files by clicking the add-in main menu –> Resources–> Send logs

      Thanks in advance