intellisense? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

intellisense?

Author

Topic

Goudinov
Starting Member

14 Posts

Posted - 2002-11-15 : 09:51:26

Anyone know when we're getting Intellisense™ for SQL? I thought VS.NET might have something, but nah...

thanks

Edited by - Goudinov on 11/15/2002 09:56:46

Natasha
Starting Member

2 Posts

Posted - 2002-11-15 : 09:58:41

Where did you hear about Intellisense and what does it offer?

N

Goudinov
Starting Member

14 Posts

Posted - 2002-11-15 : 10:10:22

Straztvui (bad transliteration, sorry),
If you use Visual Studio for programming then you've used Intellisense. It's when you are writing your code and somewhere along the way you get a drop down menu of your options. So for SQL it could work something like this.. In a table (MyTable) you have columns (ID, Desc, Image). When you start typing your SELECT statement.... you type... "SELECT MyTable." and after you type the period, a drop down list appears with "ID, Desc, Image" and you select the one you want. You'd also have full access to T-SQL functions and parameters as you type.

Edited by - Goudinov on 11/15/2002 10:11:22

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-11-15 : 10:35:42

There was some discussion of that capability once Yukon is released since it will be fully .Net aware.

Of course you can always query INFORMATION_SCHEMA.COLUMNS if you need the column names for a table, or refer to the E-R diagram.

Goudinov
Starting Member

14 Posts

Posted - 2002-11-15 : 10:40:23

yeah, writing SQL and SPs in Visual Studio.net is very easy and the SQL Server 2000 Query Analyzer is also very easy. I'm just all for making RAD a little bit RADer..ish...able..erm... yeah.

note to self, stop trying to coin phrases

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-11-16 : 08:48:01

Bah

Intellisense...who needs it

Damian

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-11-17 : 02:14:12