Microsoft has finally released a SQL Server product that includes IntelliSense for writing TSQL statements. In this article, Tim Chapman shows the ins and outs of using IntelliSense in SQL Server 2008.
If you are used to working in the Microsoft Development Environment, you've likely grown accustomed to using IntelliSense, a feature which reads internal metadata and provides a list of available objects and properties while you are developing.
However, this feature has yet to be available to the TSQL language inside the SQL Server Management Studio. I am happy, though, to say that SQL Server 2008 finally includes TSQL IntelliSense, which provides a listing of available objects to use in SELECT statements, DML statements, and stored procedure calls, along with numerous other operations.
Check out the below link
http://www.zdnetasia.com/techguide/storage/0,39045058,62047009,00.htm
Saturday, October 25, 2008
IntelliSense in SQL Server 2008
Subscribe to:
Post Comments (Atom)
3 comments:
good article....
If you like the Intellisense in SQL Server 2008 you might also be interested in trying SQL Prompt. (Full disclosure: I work for the company which makes it.) It works with SQL Server 2005 and 2008, and offers quite a lot more functionality than the SQL Server 2008 Intellisense.
You can get a copy from http://www.red-gate.com/products/SQL_Prompt/
Theo Spears
Red Gate
Thank you for visiting my blog...
Post a Comment