Comments
3 comments
-
Following on from the scroll to candidate list rather than filter suggestion elsewhere, a more context sensitive candidate list would be good.
For example, if I include functions & system functions in the options, they naturally sort to the top of the list - but most of the time I'm actually interested in columns - particularly columns on tables already referred to in my query.
As a result, columns for tables already included in a query should filter to the top of the list - making the list a more useful reminder when you don't know the name of the column you're interested in - so you want to select from a list.
So, if I have all (or most) options selected in the Items to show in candidate list, and my query so far is select * from aardvarks a join zebras z on a.id = z.id where@CONNECTIONS.
If I actually do want to use a system function, then typing @ will bring it into focus. -
Bernards, "put columns at the top of the list and functions last" really gets my vote. v1.4 is a good tool, but it is frustrating to have to turn off useful options in order to see the columns...
-
I agree, having an option to group columns together at the top and functions together at the bottom is something that would be really helpful...
Add comment
Please sign in to leave a comment.
As a result this is my first real look at an intellisence plug in for QA et al. The QA integration is important for me because I still have to use it in environments where I can't even install SSMS (XP SP2 is banned) even if I wanted to use it for SQL2K.
Following on from all of the comments in this post, some more suggestions and votes seconding existing suggestions...
I think space should select the currently highlighted entry - as per "standard" intellisence - I keep on getting the first few characters of an entry because I hit space to select it instead of tab.
Unlike QA, presents all DBs on a server rather than those that the UID being used has rights to (for example, in USE dbname).
Options to auto format indenting would make this a must have "style police" tool.