SQL IntelliSense

SQL IntelliSense

SQL Server provides a great editor for writing and executing the SQL queries. The SQL Server editor is very user-friendly and easy to work. But it has a very large weak point that doesn't provide more options for IntelliSense. It provides limited options for IntelliSense.

Tasks of IntelliSense

  1. Describes how to configure IntelliSense options such as statement completion options or the size of Transact-SQL scripts for which you want IntelliSense turned off.
  2. It provides information about how to use Parameter Info to get information about the number, names and sizes of parameters for a function or stored procedure.
  3. Describes how to use Quick Info to get tooltips that describe an identifier (such as a table or view name).
  4. Describes how to have IntelliSense complete the rest of an identifier after you have typed in enough of the name to get a short list of objects whose names start with the same string.
  5. Describes how IntelliSense can identify both ends of a pair of delimiters and how you can jump between the two ends of the pair.

    Today we learn about the SQL Complete IntelliSense Tool.

SQL Complete

This is a very useful tool and provides good IntelliSense help in SQL Server. This is the best IntelliSense software that I have used until now.

First of all we need to download this software.

You can download this software from SQLComplete.

After installing you will see a new menu option "SQL Complete" in SQL Server menu.

SQL Complete image

Then whenever we write a T-SQL query it will provide a suggestion.

suggestion

It also provides the information about the field of a table and their datatypes.

datatypes

We can get information about a system defined function with their definition and return type.

information

Find Definition

We can find the definition of any database object, like table, view or stored procedure.

  1. First of all, put the cursor on any database object.
  2. Now select the SQL Complete Menu option.
  3. Then click on the “Go To Definition” option.

    Go To Option

Format Document

The formation of a document is always a hassle and a bother for a programmer. But we can easily complete this take using the SQL complete tool.

Formation of a document

Let us see an example.

Query before format document:

Query before format document

Now we select the Format Document  option from the SQL Complete Menu.
The following is the query after format document:

Menu

Execute Current Statement

Assume we have more than one query in SQL Editor. If we execute the operation then SQL Server will provide the output for all the queries. But if we want to execute a specific query then we will select the entire query then execute operation. This task becomes very difficult since the size of the query is very large.

But SQL Complete provides a solution for this problem. We use the “Execute Current Statement” option from the SQL Complete Menu.

SQL complete

If we want to execute any specific query then we need to put the cursor on that query and select the “Execute Current  Statement” option and the output of that query will be generated.

Rename Alias

Assume our query contains an alias name of a table and now we want to change this alias name. What will we do? We will go to every statement that contains this alias name and  change it.

This process takes a large amount of time and it is also a headache for programmers to rename the alias but we can do this very easily using SQL complete.

Rename Alias

First of all we need to select the alias name then select the option of “Rename Alias” and now  provide a new alias name.

emp

SQL Complete provide Option facility.

Option

Using this option we can change the setting and working of SQL Complete according to our requirements.

change the setting

I hope this article will be helpful for all of you.

Up Next
    Ebook Download
    View all
    Learn
    View all