Dan Bright's .NET Weblog

My precious (Yukon)...

A picture says more than words...

Now if only it would reflect against the current database and list all available tables...

Also, my more attainable wish:  The ability to select a block of text in the workbench and comment/uncomment it via a menu or toolbar like VS.NET...

Comments

Darren Neimke said:

The picture looks cool, but, in terms of usefulness I'd rate the dropdown about 3 out of 10. I mean, what's the point of adding the "HAVING" clause to the list when it would clearly be invalid at that point. One of the reasons that the VeeBee IDE experience is so good is that they do a great job of limiting you to valid options.
# November 20, 2003 12:00 AM

Jon Galloway said:

Agree. I hope Yukon's workbench is as good as SqlBuddy (http://sqlbuddy.sourceforge.net/screenshots.shtml). The dropdowns there are context sensitive.
# November 20, 2003 1:05 AM

TrackBack said:

# November 20, 2003 6:09 AM

Ade Bullock said:

Have a look at pl/sql developer from allround automations. It does all this for Oracle databases, and possibly for sql server as well. Its very handy having intellisense when writing sql or pl/sql
# November 20, 2003 6:28 AM

Johnny Hall said:

Ooh, and the ability to automatically create a dynamic sql call from a piece of sql, e.g.

SELECT * FROM Table WHERE ID=@ID

becomes

sp_executesql 'SELECT * FROM TABLE WHERE ID=@ID'

(details omitted for 'clarity')

That would be useful. Quoting a large SP is a pain in the behind.
# November 20, 2003 8:21 AM

TrackBack said:

^_^,Pretty Good!
# April 10, 2005 3:14 AM

My precious (Yukon)… - Dan Bright's .NET Weblog | ASP.NET Security Watch said:

Pingback from  My precious (Yukon)… - Dan Bright's .NET Weblog | ASP.NET Security Watch

# January 31, 2009 3:03 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)