Comments
Sort by recent activity
Bart Read wrote:
* What do you think of the automatic aliasing of tables?
Like others, I would like to control how the alias' are used. For example, we use a 3 character alias in our coding standard (refers to the way we name tables) and I'd like to be able to automatically use this 3 char standard. (I know that would be hard to do, but one can wish, right?)
* Do you like the auto insertion of table names when you select a column?
I think this is a nice feature. Kind of hard to keep track of sometimes though. I guess once I get used to the feel, it will work better for me.
* If you insert columns from many tables should the tables be automatically inner joined of should there be some way of choosing left outer / right outer join?
We tend to use outer joins on a regular basis, so I'd like to see some functionality there. Maybe a feature that can be toggled?
What's good? What's bad? What's downright ugly?
I really like the integrated functionality. I am using SQL Workbench, and I especially like the way SQLPrompt just "fits in". It took a little getting used to the schema box, but overall I am very impressed. One little nit though, when going back over text and editing, I find that unless I delete the inserted table alias, I end up getting duplicate "alias." entries, which invalidates the code. (For example, say I have SELECT o.customerID FROM dbo.orders as the code, and then I go back to "customerID" and change it to "orderID", what I then end up with is o.o.customerID....)
First impression says this is going to be very useful in our environment. Will add more feedback as I use it more.
Thanks..
Ted / comments
Bart Read wrote:
* What do you think of the automatic aliasing of tables?
Like others, I would like to control how the alias' are used. For example, we use a 3 character alias in our coding sta...