63 results found

1. Rank suggestions by popularity

   I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and speed up code creation

   I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and… more

   70 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   15 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

   On 14th May we released Prompt 9.5.3 which includes a feature to show recently used suggestions.

   This will be the first iteration of work to rank suggestions so we’re keen to hear feedback and ideas for improvement.

   More details in the release notes here: https://documentation.red-gate.com/sp9/release-notes-and-other-versions/sql-prompt-9-5-release-notes

2. Partial Name Matching (like the Intellisense in VS2010)

   I thought that partial matching for Intellisense was a rubbish idea, but after using in VS2010 I find it absolutely indispensable, and I really miss it in SQL Prompt.

   [b]What is it?[/b]
   An example:
   [code]
   CREATE TABLE [dbo].[Clients](
   [ClientID] [int] NOT NULL,
   [ClientName] [varchar](50) NOT NULL,
   [ClientSurname] [varchar](50) NOT NULL,
   [ClientCardNumber] [int] NOT NULL
   ) ON [PRIMARY]
   [/code]

   If I had to now type
   [code]
   SELECT
   ClientID,
   ClientName,
   ClientSurname,
   ClientCardNumber
   FROM
   dbo.Clients AS c
   ORDER BY
   $CURSOR$
   [/code]
   and started typing "Cli" I would get a list of all the column names on the table. However, if I typed "ID" I would get a list containing "ClientID".

   Try it on Visual Studio 2010 and see what I mean.

   This would help immensely in scenarios where column names are made unique.

   I thought that partial matching for Intellisense was a rubbish idea, but after using in VS2010 I find it absolutely indispensable, and I really miss it in SQL Prompt.

   [b]What is it?[/b]
   An example:
   [code]
   CREATE TABLE [dbo].[Clients](
   [ClientID] [int] NOT NULL,
   [ClientName] [varchar](50) NOT NULL,
   [ClientSurname] [varchar](50) NOT NULL,
   [ClientCardNumber] [int] NOT NULL
   ) ON [PRIMARY]
   [/code]

   If I had to now type
   [code]
   SELECT
   ClientID,
   ClientName,
   ClientSurname,
   ClientCardNumber
   FROM
   dbo.Clients AS c
   ORDER BY
   $CURSOR$
   [/code]
   and started typing "Cli" I would get a list of all the column names on the table. However, if I typed "ID"… more

   36 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   11 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  Paul Stephenson responded

   As of SQL Prompt 5.3, partial matching is now included for everyone.

3. Synonym support

   I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
   Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for its columns etc. This renders SQL Prompt's auto completion and suggestions useless in many cases for us.

   I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
   Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for… more

   102 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   23 comments  ·  Intellisense  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes full synonym support.