Advanced Autocompletion, Pretty SQL Formatting, Smart Code Refactoring

Reuse code modules

Since code reuse is essential to the efficiency of a developer's work, SQL Complete provides you with a collection of predefined code modules (snippets) and an opportunity to create your own custom snippets from any block of code, as well as easily share them with your teammates via GitHub.

The most obvious benefit is that you don't have to search for scripts elsewhere or retype code over and over. Your job simply gets done faster.

Moreover, the standardization of code structures and modules enables faster and more accurate investigation, testing, and resolution of issues.

Improve code quality

SQL Complete offers conveniently accessible refactoring tools that help you improve code quality, make it easier to understand, and refine the design of code objects and entire databases. These tools allow renaming database objects, variables, and aliases, as well as finding invalid objects.

The killer feature of SQL Complete is T-SQL Debugger, designed to troubleshoot T-SQL scripts, stored procedures, triggers, and functions. This debugger allows observing the runtime behavior of database objects and locating logic errors. It supports step-by-step execution, call stack browsing, breakpoints, and watches.

Unify SQL standards across your company

Consistency makes it easy to read, understand, review, and share code with your team. The SQL Complete Formatter helps keep your code consistent with a number of options, including wizard-aided bulk formatting, noformat tags, predefined profiles, database identifier case synchronization, word recognition in CamelCase identifiers, and other options of automated formatting, designed to simplify and speed up your operations.

What you eventually get is increased efficiency of code reviews, faster troubleshooting, and overall improved productivity of your teamwork.

Work safely with session restoration

Keeping your work safe has never been easier with the session restoration features of SQL Complete. They help minimize or completely avoid loss of code or data, recover sessions, and quickly take action in case of emergency.

The available features include safe restoration of entire document sessions, quick restoration of the last closed document, as well as such handy tools as execution warnings, transaction reminders, and execution history.

Operate with data effortlessly

SQL Complete helps you search, copy, and visualize data represented in the SSMS results grid, as well as work with this data in a variety of ways.

For instance, you can search for the required data across the results grid without having to write queries to refine search results. You can generate scripts directly from the results grid. It is also very easy to copy data from a cell or an entire table in the results grid to clipboard or to CSV, XML, HTML, and JSON files.

Finally, you get data aggregation, which is designed to help calculate sums and average values in the received data sets. This is far quicker and simpler than using spreadsheets for the same purpose.