Temporarily Elevate Exact Matches Over Recently Used Suggestions
I like the new feature to put recently-selected items at the top of the list for Intellisense. However, when I have typed an exact match, I would like to see Intellisense elevate that exact object to the top of the list.
For example, suppose I have recently selected a table named "dbo.OrderDetail", and suppose that there is another table in the same database called dbo.Order. With the new feature, I cannot access "dbo.Order" as the top candidate, because it is a partial match of "dbo.OrderDetail," and so SQLPrompt puts that name at the top.
In a nutshell, I would like the top item in the Intellisense suggestion list to be:
Highest priority: any object name that exactly matches what I've typed so far.
Next priority: any object that matches (not necessarily exactly) what I've typed so far and which I've recently selected.
Next priority: any object that matches (not necessarily exactly) what I've typed so far and which I have not recently selected.
Final priority: objects in their default order
Maybe that's not exactly perfect, but hopefully, it's specific enough for you to understand my suggestion. If my request is not clear, ping me with your questions.
Alec Stone commented
Absolutely agree with this! Only minor change I would make to Chris's suggestion is to include partial matches as well ahead of recently used. I.e. not just exact matches of complete object names but if you have typed half the name as well and it is a better match than the suggestion for most recent. Thanks.
Chris Leonard commented
This is important to me - I can't believe others don't have the same experience. When the feature is off, exact matches are favored. When you turn on the feature, recently-selected objects are favored over exact matches. This is counter-intuitive and leads to me selecting the wrong object frequently, so I have shut the feature off.