Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Intelligent use of IntelliSense

Oct 26 2012 12:00AM by Madhivanan   

I see developers often confused on how they get the list of objects by IntelliSense when writing the code. Here are some points on how you can intelligently make use of IntelliSense.

When IntelliSense is enabled, in the query window, type SELECT and a space and hit Control+Space. You will see something like below

image1

Do you know what are listed out? It lists out all objects that can follow a SELECT statement. ie all that can be immediately followed by SELECT keyword. The list includes the variables, global variables, tables, scalar udf, etc. In this list you will not see any objects that can not be SELECTed (eg Stored Procedure, extended stored procedures,etc)

If you scroll down the list, you can see the list of system functions

image2

If you scroll down the further, you can see the tables too

image3

If you select the table and type a dot, you can see the list of available columns for that table as shown below

image4

Similarly see what happens when you type EXEC and a space and hit Control+Space. You will see something like below

image5

If you scroll down the further, you can see the stored procedures too

image6

 

As you see it will list out all objects that can be part of EXEC.

This way you can effectively make use of IntelliSense to know the available objects based on what context you are in. If you don’t how why the object lists is not always same just think about the above points.

Note: If the images are not clear, please click on them for larger view

Tags: 


Madhivanan
3 · 40% · 12898
10
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

12  Comments  

  • Wanted to add a point that some time it happens that you have created a new object(table, procedure etc) and it is not listing through IntelliSense. In this case we need to refresh local cache. Shortcut to refresh local cache is ctrl+shift+R.

    Regards Jeetendra

    commented on Oct 26 2012 7:48AM
    Jeetendra
    144 · 1% · 342
  • Thanks Jeetendra. Thats a good point

    commented on Nov 1 2012 5:21AM
    Madhivanan
    3 · 40% · 12898
  • I'm curious as to why "coalesce" is not in IntelliSense options. ISNULL is, but not Coalesce. Also, when I am writing wondow functions, sometimes "PARTITIONFRAGMENTID" has stuck itself in there. It drives me nuts.

    Thanks for the ctrl+shift+R hint. You shaved off at least 3 stress points right there.

    commented on Nov 6 2012 3:52PM
    Amy
    493 · 0% · 77
  • Hi Madhivanan,

    I am using sql server 2008 r2 standard edition in my local machine. since today morning intellisense is not working for me.

    Tools-->options-->Text Editor-->Transact SQL-->Intellisense is enabled already.

    Can you please suggest any necessary steps.

    commented on Jan 18 2013 4:03AM
    Bala Krishna
    83 · 2% · 676
  • Bala krishna, Can you open a new session and try?

    commented on Jan 18 2013 4:19AM
    Madhivanan
    3 · 40% · 12898
  • Madhivanan Thanks for your quick reply.

    I have opened new session and also because of local machine i have ReStarted the service as well. But no result

    commented on Jan 18 2013 4:30AM
    Bala Krishna
    83 · 2% · 676
  • Are you sure you are using version 2008 and Intellisense is enabled? Also type SELECT and a space and then press CTRL+space bar. See if you get popup menu

    commented on Jan 18 2013 4:44AM
    Madhivanan
    3 · 40% · 12898
  • Yes, i am using 2008 R2 only. SELECT @@VERSION --Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    And i have typed SELECT and a space then CTRL+ space But Nothing is coming.

    commented on Jan 18 2013 5:10AM
    Bala Krishna
    83 · 2% · 676
  • Right Click and make sure that Intellisense Enabled is enabled

    commented on Jan 18 2013 5:18AM
    Madhivanan
    3 · 40% · 12898
  • Yes, Its enabled only.

    commented on Jan 18 2013 5:28AM
    Bala Krishna
    83 · 2% · 676
  • Thanks for sharing use full links.

    Still am having the same intellisense problem.so am going to do some RND now.

    Thanks a lot again.

    commented on Jan 21 2013 4:25AM
    Bala Krishna
    83 · 2% · 676

Your Comment


Sign Up or Login to post a comment.

"Intelligent use of IntelliSense" rated 5 out of 5 by 10 readers
Intelligent use of IntelliSense , 5.0 out of 5 based on 10 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]