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 introduces a new feature of 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 small demo of this feature here.
This image list all the objects from inside of selected database as above.
I hope you liked this new feature and post as well. Happy Development!!!
But SQL Server 2008 introduces a new feature of 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 small demo of this feature here.
CREATE DATABASE IntellisenseDB GO USE IntellisenseDB GO IF ( Object_id('IntellisenseTable') > 0 ) DROP TABLE IntellisenseTable GO CREATE TABLE IntellisenseTable ( Id INT, Value VARCHAR(10) ) GOLet's look at the below images, how intelligence works. From below screenshot, I am selecting the database created above.
This image list all the objects from inside of selected database as above.
I hope you liked this new feature and post as well. Happy Development!!!