Generating aliases automatically
SQL Complete automatically generates aliases after you type the name of an SQL object, and you can later refer to that object by the alias. Moreover, SQL Complete allows you to
create custom aliases and also map them using alias condition masks. IntelliSense does not have the option of automatic alias generation.
Detecting database context
SQL Complete knows the database you are working in and suggest a list of its objects sorted by type and alphabetically, whereas IntelliSense just shows the
databases based on your current connection.
Highlighting identifier occurrences
Clicking one identifier will highlight all other occurrences of this identifier throughout the entire SQL document, which is not the case with Visual Studio's native IntelliSense.
After you type JOIN, SQL Complete offers all possible joining combinations with table names and joining conditions based on foreign keys of the current table.
You don't need to manually type the entire JOIN clause, just select the necessary one from the list of suggestions. As you can see on the screenshots below,
IntelliSense only offers the list of databases.
OUTER APPLY instead of APPLY, ORDER BY instead of ORDER - don't settle for less with SQL Complete, you get not just individual words, but entire code phrases.
You will be prompted the ON NULL attribute after a created scalar-valued function, context-based prompts for data types and primary keys of server objects in the CREATE TYPE
statement. At the same time, IntelliSense will make you manually type the entire phrase.
The Parameter Info feature of prompts the details of parameters used in the function you type. This information is neatly displayed in
the Parameter Info hint shown right in the editor. In contrast, no such info is shown as you type the function name if you use IntelliSense.
With SQL Complete, you get basic information about a database object right off the bat simply by
hovering over the object identifier. A table hint shows column names and data types, additional column properties, primary, unique, and foreign keys.
An asterisk hint after the SELECT statement shows a list of columns. An alias hint in the FROM statement shows a table/expression with a column list,
and much more. IntelliSense's object info hint shortly describes an object without any extra details.
A hint with table details
Pretty useful info that SQL Complete shows for a table identifier includes a list of columns with data types and an estimated number of rows it contains.
These details are also shown if you hover over the table alias.
IntelliSense is missing this one too.
Add missing semicolons
A very helpful feature Insert Semicolons is accessible from the pop-up menu of SQL Complete,
or you can simply press Ctrl+B, Ctrl+С and semicolons will be added throughout the document where required.
you will need to type them by hand, which is rather time-consuming.
When you type the SELECT statement, SQL Complete gives you an ability to select multiple columns from the pop-up dialog box and insert them in the code at once
instead of typing them manually as would be the case with IntelliSense.