Feature Request - Ranking suggestions by popularity

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Feature Request - Ranking suggestions by popularity

Postby PaulGoldstraw » Thu Jun 17, 2010 11:23 am

When using SQL Prompt 4, it would save time if the program remembered the most popular choices selected. For instance, when typing the table name [Customer], i type CU then hit tab but it performs the code snippet CREATE USER. If CU eventually settled on Customer as the most popular result, with the snippet below because i never use it, the time taken to write the code would decrease.

Another example is that we have numerous tables that start with the same name, for instance, MerchantStore, MerchantSystem and MerchantSettings. On almost every occasion I will want MerchantSystem, but this is the last of the 3 alphabetically. If the popularity of the selection were taken into account it would gradually end up a the top of the results, making things more efficient

Presumably if the list of entries is stored for display, a ranking for each item to order it by most popular first might be fairly easy to implement


Posts: 10
Joined: Thu Jun 17, 2010 11:00 am

Postby David Atkinson » Thu Jun 17, 2010 12:49 pm

Thanks for the suggestion. We've logged this as a feature request and we'll consider it for a future release.

I guess in the first case you can simply remove the CREATE USER snippet?

Kind regards,

David Atkinson
Red Gate Software
David Atkinson
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby PaulGoldstraw » Thu Jun 17, 2010 1:00 pm

I could remove it, yes. I tend to think the snippets are there to help when you think to use them, so I am reluctant to remove them unless I really have to, otherwise it's almost like i'm defeating the object of their presence. Thanks for looking into this though

Posts: 10
Joined: Thu Jun 17, 2010 11:00 am

Postby kondrich » Fri Jun 18, 2010 7:18 am


I agree with you: This would be a great feature.
It would be as useful as Firefox ranks browsing history entries.
Regards, Klaus
Posts: 60
Joined: Thu Jun 10, 2010 10:44 am
Location: Vienna, Austria

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests