63 results found

1. GROUP/ORDER BY Suggestions

   It would be nice, if the suggestions list for GROUP BY would include all the all the not aggregated SELECT list columns first.
   For ORDER BY, all the columns/aliases or their ordinal, and add checkbox for ASC/DESC.

   72 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

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

   SQL Prompt 6.5 now suggests the non-aggregated columns first for GROUP BY, with aggregated columns suggested first in HAVING clauses. You can download this version from http://www.red-gate.com/products/sql-development/sql-prompt/

2. 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.

3. 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.