dbForge SQL Complete Express

По некоторым ключам 0 частота, но есть позиции. Я их относила к категории blue, стоит перепроверить частоту

dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense ®. Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter.

Key Features

Smart filtering to suggest relative keywords and objects

SQL Complete filters the suggestion list based on various criteria: first typed symbols, a whitespace, camel case, a square bracket. You can be sure, whatever you type, the suggestions will be just what you wanted.

SQL Query History

SQL Query History stores information about previously executed queries for a specified period of time. This information includes query text, size, status, associated database and server, and further details about the execution that might come in handy in a number of cases. For instance, you can do the following:

• quickly access and run queries that must be executed regularly
• investigate a particular work case (e.g., if there is a problem likely caused by a query, you can quickly locate it and address the problem most effectively)
• check the backup history
• recover a specific query if your SQL Server crashes

Parameter information for functions

When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.

Customizable SQL formatting (partial support')

Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.

Context-sensitive suggestion of keywords (partial support')

SQL Complete thoroughly defines the context to predict what you want to type next. It displays only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.

Determining a current database or schema

SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query. The names of the current database or schema are determined based on connection properties of the current SQL document. Besides, SQL Complete finds USE statements in the code and changes the current database for subsequent SQL statements.

Semi-transparent view of the suggestion box

When your code is overlapped by the suggestion box, do not close the suggestion box. Hold Ctrl to make the suggestion box switch to semi-transparent view.

Execute current statement

Now user can execute the current SQL statement without selecting it. You can just place the cursor within the statement and select the needed menu item from the context menu - and SQL Complete will define statement boundaries itself.

' Partial support comparing to the Enterprise edition of dbForge SQL Complete