Activity overview
Latest activity by bert
With all those promises, you get yourself a huge responsibility :lol: ! Good luck fixing and building! / comments
With all those promises, you get yourself a huge responsibility :lol: ! Good luck fixing and building!
Bart Read wrote:
User hits ENTER -> INNER JOIN added to FROM clause
User hits any other completion key (DOT, SPACE etc) -> table simply added to FROM clause (=cross join)
User hits CTRL + ENTER => LEFT OUTER JOIN
User hits SHIFT + ENTER => RIGHT OUTER JOIN
User hits CTRL + SHIFT + ENTER => FULL JOIN
How does that sound?
That sounds better. Enter and Ctrl+Enter are the most instinctive buttons since the combination is often used in other software. To couple these commands on INNER and LEFT (OUTER) join is imo the best way. The other two commands are also good, perhaps the FULL JOIN will be a bit difficult to remember, but who cares when it is relatively rarely used [image] ?
Conclusion: I definitely think you're on the right way to perfection! / comments
Bart Read wrote:
User hits ENTER -> INNER JOIN added to FROM clause
User hits any other completion key (DOT, SPACE etc) -> table simply added to FROM clause (=cross join)
User hits CTRL + ENTER ...
Never mind, in the mean time we hover the mouse over it to let it disappear :lol: ... / comments
Never mind, in the mean time we hover the mouse over it to let it disappear :lol: ...
I agree. When typing comments, nothing is more frustrating than some 'helping tool' trying to help you flush your mind [image] .
In literals, I would also like to have to opportunity to use intellisense, but when it appears, it should be providing me real good information. / comments
I agree. When typing comments, nothing is more frustrating than some 'helping tool' trying to help you flush your mind .
In literals, I would also like to have to opportunity to use intellisense, ...
Ctrl + Arrow normally moves one word at a time. That was when I discovered the feature. However, I can live with it and am possibly going to love it... / comments
Ctrl + Arrow normally moves one word at a time. That was when I discovered the feature. However, I can live with it and am possibly going to love it...
INFORMATION_SCHEMA does not appear in the list after 'SELECT * FROM'. That one is a requisite for me since a lot of information can be pulled out of it.
Keep up the good work! / comments
INFORMATION_SCHEMA does not appear in the list after 'SELECT * FROM'. That one is a requisite for me since a lot of information can be pulled out of it.
Keep up the good work!
Automatic aliasing is fine by me. It is really effective, albeit that I would like the '*' to be prefixed as well. HotAir's remark about 'a.' is definitely my point as well.
When joining, I would like to have an opportunity to choose between left and inner join, imho the mostly used joins. In our company we made an agreement we never right join, because always inner joining or left joining provides the most clear sql scripts (especially as we sometimes join more than 20 tables).
I would like working Intellisense in dynamic sql scripts, but I don't know how hard that one is for you. It should not be that hard to combine a string and use your already built intellisense system on that. But who am I [image] ... / comments
Automatic aliasing is fine by me. It is really effective, albeit that I would like the '*' to be prefixed as well. HotAir's remark about 'a.' is definitely my point as well.
When joining, I would l...
First impression and a few bugs
Hi, I downloaded SQL Prompt about half an hour ago and I like the way it works. Since it is a beta, I understand not everything should work well, but the following points are the most interesting f...