Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

86 results found

  1. I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:

    https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory

    So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?

    While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. It would be great if you would introduce a new setting where we can turn of update- and other notifications (like "SQL 2008R2 not supported") warnings.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. With SQL Prompt, and selecting "Copy as IN clause" on a resultset, is it possible to format the result as all one line, like:

    IN (1,2,3,4,5,6)

    instead of what it does currently:

    IN (

    1,

    2,

    3,

    4,

    5,

    6) ?

    Having it all on one line makes a statement easier to read, when there are a lot of items in the list.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. SQL Prompt allows users to set custom directories for various files.

    It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.

    I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.

    The only way to do this now is via REGEDIT.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. Allow save and re-load a set of filters. We work in schemas by project and every morning starts with filtering all my objects by schema, and I would love to reapply filters as a set.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. I often need to wrap a column in a coalesce with 0.
    It would be swell if there was a feature where I could select a column, then either right click or Keyboard shortcut to have it wrapped in coalesce.
    E.g. select the word
    personCount
    and have it be replaced with
    coalesce(personCount,0) as personCount

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. i have file excel multi column about 100 column.
    I suggest feature, when i open excel, auto create struct insert table.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. The recent roll-out of SQL History was handled very poorly. SQL History isn't simply an update to Tab history else there would not have been the need for a name change. SQL History is an alternative feature meant to do what Tab History does (I hope) and more but on roll-out it made many of your paying customers not only angry because you replaced Tab history with it but because it wasn't ready for roll-out.

    In the future when you feel the need to replace an existing beloved feature with something different and not just an update, DON'T! Instead roll…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. Hello Redgate and the community,
    During my day to day work, it would be greatly helpful to get a shortcut to enter the filter setting menu, not only on databases, but also tables, views and stored procedures and what not, just a global shortcut, to enter the filter setting on the selected folder (if that is available for the folder)

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. In version 10.12.1 and older the "Open in Excel" functionality actually created a Excel file where numbers were numbers and could be used in formulas like SUM. Starting in, I think, 10.12.4 you started exporting all numbers as a string. That completely breaks the usability, as you can then no longer make a formula using the numbers. (And while Excel offers the option to convert them back to numbers, it would be a pain to do it for each column that needed it and it takes FOREVER.)

    At this point I will have to stay on 10.12.1 and not upgrade…

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. Currently the files write out to a temporary file location. Add pane in settings window to change the location (e.g. a folder in my one drive that is not read only)

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. When working on a management server with SQL Prompt and SSMS, we usually don't have Microsoft Office with Excel installed there. This makes it very cumbersome to use the current feature of SQL Prompt to export grid results to an Excel file as there is no application available on the server to process the file.

    Instead, I often use a very nice feature in SSMSBoost that copies to grid results data to an XML spreadsheet which can then be pasted into Excel on your client, preserving data types. The regular copy/paste from SSMS to Excel only copies text data from…

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. It would be useful to have snippets included when searching in the command palette. Selecting snippet would open snippet editor with focus on the selected snippet.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. There is a feature that was in WinSQL where each field in a column would have a little plus sign if it had a foreign key. If you click the plus sign it would look up that value in the table with the foreign key in a new tab (it would give a choice of tables if there are more than one, then do the lookup).
    It was very useful and a great learning tool; it would be a great addition to SQL Prompt. Pictures attached.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Before I upgraded to latest version of SQL Prompt, if I had two queries in the same "New Query" window and ran them, I could select either of the two result sets and choose "Open in Excel" to open up the selected result set in Excel. Now it always seems to auto-select the first result set.

    What I'm usually doing here is two related queries. I pick the larger result set, open that in Excel, and then add a new tab to Excel and copy-and-paste the smaller result set to the 2nd tab. Or sometimes I'm doing multiple queries to…

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. I would like to be able to specify different script blocks inside a snippet that would work differently based upon the sql server version of the server I am connected to.

    Or.... optionally have a version indicator on the snippet to perform the same thing. Then if two snippets share the same name it would apply the correct one based upon version.

    EX:

    :if $version_major$ >= 13
        CREATE OR ALTER PROCEDURE [$dbo$].[$proc_name$] (@param1 INT) AS BEGIN
            $CURSOR$SELECT @param1
        END
        GO
    :else 
        IF OBJECT_ID('[$dbo$].[$proc_name$]', 'P') IS NULL BEGIN
            EXEC('CREATE PROCEDURE [$dbo$].[$proc_name$] AS BEGIN SELECT 1; END;')
        END 
    
        GO
        ALTER PROCEDURE [$dbo$].[$proc_name$]
    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. I often find myself in a scenario where I am doing something like:
    1. Mock some data (SQL query)
    2. Perform a front end action as though I'm a user
    3. Check some data (SQL query)
    4. Alter a procedure (SQL query in a different window)
    5. Repeat

    I think it would be nice if I could pin the mock/check queries to a window in the side of the manager so that I could click to run them instead of having to click in them then shift+f5 or whatever. And even more nice not having to have a second editor…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Tab Colors add a great feature to know I am on a production server. It would be improved by being accessibility compliant. In the attached you can see black on red is harder to see than white on red.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Allow dark theme for all GUI interfaces in Prompt.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. It would be very useful to be able produce where clause from copied horizontal selection from the results grid. For example from the uploaded image, where clause should be

    WHERE CTA.TRANSACTIONDATE = '2021-06-27'
    AND CTA.TRANSACTION
    TYPECODE = 52
    AND CTA.ITEM
    CODE = 1500012200
    AND CTA.ITEMBARCODE = '8001841964966'
    AND CTA.YOUR
    COMPANYCR = 104183
    AND CTA.OTHER
    ENTITY_CR = 46084

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3 4 5
  • Don't see your idea?