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

(thinking…)

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

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

279 results found

  1. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  2. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  3. Bring back the Ctrl+B, Ctrl+B hotkey for removing square brackets please. I used it all the time and the last update seems to have removed

    I updated to SQL Prompt 9.4.7.7595 yesterday and since then I no longer have the hot key. It is still on the menu, but no hotkey. I used that feature hourly. If you wish, allow users to define the hotkey combinations or disable them, but simply removing them is inconvenient.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Admin →

  4. A Create/Declare Table statement with a Primary Key gives a false positive BP014 in Code Analysis

    If you have a table declared like this:
    Declare @Test table
    (TheKey int Primary Key,
    SomeData varchar(10) Not Null)

    I am told that for "TheKey" "[NOT] NULL option is not specified in CREATE/DECLARE TABLE statement" defined. But, a Primary Key can never be null, so it is NOT NULL by nature.

    So, when performing Code Analysis and the parser sees "Primary Key", "Not Null" should be inferred also.

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Code Analysis  ·  Admin →

  5. Duplicate Tab

    One of the common UI interaction features in browsers like Chrome and IE is Duplicate Tab feature.

    Ususally the reason you might want to do this, could be because you want to keep an UNALTERED TAB and do SOMETHING DIFFERENT with another page...

    In SSMS this could be a great feature. Example of use please (- I hear you ask)? You could be trying to change script and test the effect of that change vs the original!

    MUCH MUCH Further down the line, you could extend this feature, to highlight the differences between tabs, a bit similar to file compare…

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  6. Add support for Azure Active Directory authentication

    Referring to this forumpost: https://forums.red-gate.com/viewtopic.php?f=169&t=79794

    55 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    8 comments  ·  Admin →

  7. Sum selected columns

    It would be nice to have some capabilities that exist in Excel 2013. Specifically the feature when you can highlight a column and then at the bottom of the application it gives you some quick statistics for the column. So if I had a column of numbers, and I highlighted the column in the results pane it would give me the Average of the numbers in that column and the sum of the numbers in the column. If the column was text you could see the count of distinct values in that column. This just gives quick access to statistical…

    35 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  User interface  ·  Admin →
    completed  ·  AdminTim Dalton (Product Manager, Redgate) responded

    The ability to show the aggregate values of a selection of cells in the result grid was added as part of SQL Prompt 10.15 https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-15-release-notes.

  8. Command Line "Reformat All Files In Folder" and pre-Commit

    Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.

    Many of Red Gate's tools provide command-line functionality.

    Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).

    Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.

    109 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    28 comments  ·  Format SQL  ·  Admin →

  9. Add the option to replace NULL values for strings as empty strings when using 'Open in Excel'

    When using the new feature 'Open in Excel' (the results from the grid), it'd be handy to have an option to replace NULL string values with empty strings ''. Sure you could do ISNULL on all the columns that are a string data type, but it'd be handy to just have the option to have the 'Open in Excel' feature do it.

    The only way I've found to quickly do it is to export the data as a csv and use a powershell script with something like:
    Export-CSV -NoTypeInformation -Encoding "Unicode" -Delimiter "," $AttachmentPath
    (Get-Content $AttachmentPath) -replace "`0", "" |…

    8 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Admin →

  10. Warning on delete and update statements if no WHERE clause is specified

    It would be nice to get a warning on delete or update statements if you did not specify a where clause.

    23 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Format SQL  ·  Admin →

  11. Allow me to specify schemas to include or exclude

    The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.

    34 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    10 comments  ·  Intellisense  ·  Admin →

  12. Let cursor jump to capitalized letters within words (CTRL+arrow)

    Hi there. Would it be possible to program a feature that is
    present in Visual Studio (I think ReSharper brings it
    into VS) which enables a programmer to select/move among
    parts of a word based on where the capital letters are? (CTRL+arrow)
    Say you have a variable called @ThisIsMyVariable.
    If you place the cursor at the end of the word and then
    press CTRL+<Left Arrow>, then it’d be nice if the cursor
    jumped to the beginnig of the next capital letter instead
    of the next word as is usual. This feature is very helpful in VS and I think it’d…

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Admin →
    completed  ·  Aaron Law responded

    The latest version of Prompt has an experimental feature for “Change keyboard shortcut behavior for CamelCase words”

  13. Set to off "Restore open tabs when SQL Server Managerment Studio starts"

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Tab history  ·  Admin →

  14. Put single quote marks around highlighted text (including multiple lines)

    Very often i have copied a list of items i want to query in an IN() statement from the database, for example:

    abc
    def
    ghi
    jkl

    and I want to format it like this:

    'abc'
    'def'
    'ghi'
    'jkl'

    or better yet:

    'abc'

    , 'def'
    , 'ghi'
    , 'jkl'

    Being able to highlight, right click, and select an option do do this, would be incredibly helpful.

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  3 comments  ·  Format SQL  ·  Admin →

  15. Formatting SQL Transaction

    It would be nice to have the code within a BEGIN TRAN and COMMIT be indented.

    BEGIN TRAN
    <ssss>INSERT....
    <ssss>UPDATE....
    COMMIT TRAN

    6 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  Format SQL  ·  Admin →

  16. 2014 ctp2 support

    please add support for sql 2014 ctp2, i'm already using it and im sure others are as well and quite frankly i've grown very accustomed to using sql prompt that it became quite hard to work without it.

    i hope you can add the support really soon

    9 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  5 comments  ·  Intellisense  ·  Admin →

  17. Code Analysis config to flat file

    Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway…

    7 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Intellisense  ·  Admin →
    completed  ·  Alicja Leszczynska responded

    Hello,

    We added this feature recently (in SQL Prompt 9.1.0.4138).

    Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….

    Let me know if you find it helpful.

    Kind regards,
    Alicja

  18. code analysis blocks object detail

    SQL Prompt v9.0.2.3223 use of Code Analysis has stopped the tooltip for showing structural details.

    ie: statement like SELECT a,b,c FROM dbo.TableRequiringLock WITH (ROWLOCK, XLOCK) WHERE ID = @key

    will just show TABLE HINT used when hovering over table name as opposed to showing the structure.

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Intellisense  ·  Admin →
    completed  ·  FabiolaB responded

    Hi,

    I am pleased to inform you that your request has been taken into account. Please update to the latest version in order to use it!

    Regards,
    Fabiola

  19. Add an analysis rule checking for semicolons as statement terminators.

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Admin →

  20. Query Execution History

    Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.

    106 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    27 comments  ·  Admin →
2 4 5 … 13 14
  • Don't see your idea?