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

Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

With new feature of SQL Server 2008 - Intellisense

Jun 17 2011 10:15PM by Paresh Prajapati   

In SQL Server 2005 or previous version , whenever I was working to write the script, query or stored procedures at that time if i forgot object names which was going to used in the script, then i was need to get the proper object name by system query or from the list of objects in management studio.

But SQL Server 2008 introduce a new feature for the above such problem. Yes that is "Intellisense" feature. Using it we can easily get all the objects list in query analyzer. I am going to put very very small demo of this feature here.

Creating objects.


USE IntellisenseDB


IF ( Object_id('IntellisenseTable') > 0 )
  DROP TABLE IntellisenseTable


CREATE TABLE IntellisenseTable
     Id    INT,
     Value VARCHAR(10)

Let's look at the below images, how Intellisense works. From below screen shot , I am selecting the database created above.

This image list all the objects of  inside of selected database as above.

I hope you liked this new feature and post as well. Happy Development!!!

Tags: sql, sql server 2008, tsql, sql server, ms sql, ms sql server, t-sql, mssql, database, sql server general, SQL Scripts, SQL new features,

Paresh Prajapati
6 · 23% · 7533


Your Comment

Sign Up or Login to post a comment.

"With new feature of SQL Server 2008 - Intellisense" rated 5 out of 5 by 3 readers
With new feature of SQL Server 2008 - Intellisense , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]