Home All Groups Group Topic Archive Search About

When is intellisense to be added to SQL 2005

Author
9 Dec 2005 3:40 PM
PeterT
Can any body let me know when Intellisense is to be added to SQL 2005?  I am
stil in shock having found out that it does not support it.

Author
9 Dec 2005 10:35 PM
Martijn Tonies
> Can any body let me know when Intellisense is to be added to SQL 2005?  I
am
> stil in shock having found out that it does not support it.

It's more of a client tool thing, not SQL Server 2005 by itself ;-)

Anyway, you might want to give our database developer tool a try:
Database Workbench.

One of the things it does, is SQL Insight (which is how we call
this).

Check the "what's new" page here:
http://www.upscene.com/products/dbw/whatsnew.htm


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Author
10 Dec 2005 11:05 AM
Tibor Karaszi
> Can any body let me know when Intellisense is to be added to SQL 2005?

Most probably never, but possibly in the next release. It was in an early beta, but that was one of
the feature that was withdrawn (one reason was the feedback from the beta testers). I use
www.promptsql.com for intellisense...

Show quote
"PeterT" <Pet***@discussions.microsoft.com> wrote in message
news:AE770C40-68D5-48BE-B6E3-1961445894A5@microsoft.com...
> Can any body let me know when Intellisense is to be added to SQL 2005?  I am
> stil in shock having found out that it does not support it.
Author
28 Dec 2005 4:51 PM
Trex
oh, I agree!  This came up in one of our team's discussion...of all the
advances they had taken, we were surprised their "Query Analyzer" equivalent
tool was unchanged in this error...along with the compiler error messages
that continue to be pretty lame.  Nevertheless, I know it's tough to make
everyone of us happy...

Show quote
"PeterT" <Pet***@discussions.microsoft.com> wrote in message
news:AE770C40-68D5-48BE-B6E3-1961445894A5@microsoft.com...
> Can any body let me know when Intellisense is to be added to SQL 2005?  I
> am
> stil in shock having found out that it does not support it.
Author
28 Dec 2005 10:50 PM
Erland Sommarskog
Trex (randytrex***@hotmail.com) writes:
> oh, I agree!  This came up in one of our team's discussion...of all the
> advances they had taken, we were surprised their "Query Analyzer"
> equivalent tool was unchanged in this error... 

Intellisense for Transact-SQL is something which is quite more
complicated than for other languages.

Personally, I keep intellisense on in Visual Studio and the like, because
I tell myself that I need it, since don't know that stuff too well. But
it gets in the way, just as often as it helps.

Anyway, there is a third-party product, PromptSQL, which claims to give
you intellisense in both Mgmt Studio and QueryAnalyzer. www.promptsql.com.

> along with the compiler error messages that continue to be pretty lame.

Yeah, the accuracy of the error messages from SQL Server is not
always fantastic. Love it when you have a 100-line query, and SQL
Server tells you that there is an non-existing column, and only points
you to the first line of that query.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button