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.
| Author |
Topic |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2009-04-21 : 12:05:25
|
How great would that be for writing queries, views, etc?  I'm actually surprised it's not available... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-21 : 12:08:51
|
| It's available in the SQL Server 2008 Management Studio.I actually hate it, it always "senses" the wrong thing for me. |
 |
|
|
im1dermike
Posting Yak Master
222 Posts |
Posted - 2009-04-21 : 12:16:53
|
| Oh wow. Does it not give you a drop down of possible/probable matches like Visual Studio does? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 12:19:19
|
| There are products e.g. http://www.red-gate.com/Products/SQL_Prompt/index.htmAs sql server 2008:Tools, options, Text editor, Transact SQL, Intellisense -- disableTara will probably like it but anyone who types while looking at their fingers.....==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 12:23:17
|
quote:
Originally posted by im1dermike
Oh wow. Does it not give you a drop down of possible/probable matches like Visual Studio does?
Well yes - then you hit space or . and it takes one of them. If you name derived tables like a and t it's a real painselect tempdb.*from sysobjects t==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
im1dermike
Posting Yak Master
222 Posts |
Posted - 2009-04-21 : 12:28:48
|
| Cool. Yeah, I assumed it worked the same as in VS. I rarely derive tables so it seems like it would be useful for me. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-04-21 : 12:40:34
|
| select IDENT_CURRENT from sysobjectsI wanted select idfrom sysobjectsAlso it has a habit of converting keywords to upper case whereas all keywords should be in lower case (anyone who disagrees is mistaken!).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-21 : 12:55:45
|
From what someone described (Anders maybe?) one of the reasons they made LINQ work backwards from regular SQL is so it would be easier to support Intellisense. Having used it in SQL 2008 I can see their point.Anything to keep developers from learning the database I suppose... |
|
|
|
|
|
|
Management Studio Intellisense