Monday , May 20 2024

What is SQL Server IntelliSense

IntelliSense was introduced with SQL Server 2008. With this feature, we can now write TSQL Code in a more practical way.

So where can we use this IntelliSense feature?

ParameterInfo: When we want to use the variables we defined, we can see the list and types of variables defined as follows when we type @ sign.

Complete Word: When you type part of a variable name, command or function name and press tab, the sql server completes the rest automatically. For example, if you type @uz for the parameter @uzunbirdegiskenismi and press tab, it will automatically complete the rest.

Quick Info: When we move the mouse over a variable in the code, it gives information about that variable.

Automatic Matching of Syntax Pairs: When writing code in TSQL, when we use “(, BEGIN, BEGIN CATCH ve BEGIN TRY” delimiters, when we close these delimiters with “), END END CATCH ve END TRY”, SQL Server mark the start and end delimiters as follows to write code easily.

IntelliSense is enabled by default. But if you need to enable it, go to Tools-> Options anc select Enable IntelliSense.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *