270 results found

1. 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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Paul Stephenson responded

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

2. Quicker way to disable / enable

   Some users report that having to go into options to disable prompt temporarily is long winded. Can there be a quicker way (perhaps a keyboard shortcut or direct menu option)?

   5 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

   1 comment  ·  User interface  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   I’m going to close this idea to return your votes since I think it was completed a while back (you can disable suggestions with Ctrl+Shift+P or from the Prompt menu). If I’ve misunderstood then feel free to create another idea with more specifics.

3. Support for XML functions

   The XML data type methods are CASE-SENSITIVE - so SQL Prompt must NEVER EVER uppercase those! I have been requesting this feature for a long time. Please fix this.

   37 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

   4 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   We’ve released SQL Prompt 6 which includes support for XML functions.

4. Improve SQL code formatting options
   90 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

   25 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Andrei Rusitoru responded

   SQL Prompt 8.0 includes many improvements to the SQL formatting options. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

   You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/

   Thank you for your help!

5. Disable SQL Prompt on certain databases

   In previous versions of SQL Prompt, I could tell it to ignore certain databases for generating intellisense. We have a couple of databases that are causing issues with the product when it attempts to load the schemas. I would like to have the ability to turn off SQL Prompt for certain databases back.

   26 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

   12 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   SQL Prompt 6.1 has now been released which includes an option page for filtering server and database connections.

6. Uppercase keywords without changing layout

   I used this all the time in SQL Refactor for code I wanted to make easier to read but didn't want to have layout changes.Can we have it back?

   12 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

   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Paul Stephenson responded

   Uppercase Keywords is now available in SQL Prompt 5.1.

7. Jump to object explorer

   I just had a situation where I was in code, didn't have the object explorer opened up for the connection and wanted to look at the table properties, security etc.

   It would be really good if you good offer up a "go to object in object explorer" feature - similar to the F12 shortcut to load an ALTER tab, but just changes the object explorer focus to the object that I am currently at.

   29 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

   12 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/

8. 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 →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Aaron Law responded

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

9. Reinstate SQL Refactor shortcut keys

   Please let us have CTRL+U back for setting reserved words to uppercase (this shortcut seems to have disappeared) as well as CTRL+B+L for layout. CTRL+K+Y isn't as natural to use and I'm giving serious thought to downgrading to the previous version. I've been used to those shortcuts for years and all it's doing now is annoying me and getting in the way.

   8 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

   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   completed  ·  Paul Stephenson responded

   In SQL Prompt 5.1, Ctrl+B Ctrl+L now activates Format SQL (Ctrl+K Ctrl+Y still works too), and Ctrl+B Ctrl+U activates Uppercase Keywords.

10. Date time types default to UTC and cannot be changed

    Whenever I use the INSERT INTO template in SQL Prompt 5, I get an incorrect date and/or time inserted for all date/time columns detected in the table. The time is 8 hours ahead of my time zone. I am on Pacific Standard Time, thus running the INSERT INTO template at say, 4pm, will generate a default date/time stamp of the next day at midnight (2011-01-06 16:00:00 real time produces a default insertion of 2011-01-07 00:00:00 for all date/time column values in the proposed INSERT statement). My assumption is that the default time is set to UTC which makes sense for Red Gate.

    It would be great if SQL Prompt could detect and use the time zone on the server.

    Whenever I use the INSERT INTO template in SQL Prompt 5, I get an incorrect date and/or time inserted for all date/time columns detected in the table. The time is 8 hours ahead of my time zone. I am on Pacific Standard Time, thus running the INSERT INTO template at say, 4pm, will generate a default date/time stamp of the next day at midnight (2011-01-06 16:00:00 real time produces a default insertion of 2011-01-07 00:00:00 for all date/time column values in the proposed INSERT statement). My assumption is that the default time is set to UTC which makes sense for… more

    7 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

    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    completed  ·  Aaron Law responded

    Prompt 6.3 uses GETDATE() rather than inserting a string literal with the current date