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 125
sql 124
ms sql server 119
ms sql 118
database 109
tsql 81
#SQL Server 78
t-sql 75
#sql 71
sql server general 67

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.
CREATE DATABASE IntellisenseDB

GO

USE IntellisenseDB

GO

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

GO

CREATE TABLE IntellisenseTable
  (
     Id    INT,
     Value VARCHAR(10)
  )

GO 
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% · 7454
3
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

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]