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

277 results found

  1. Shortcut for Switching Styles

    Can you add "choose style" or "switch style" to the commands section, as a drop down, so that it can be added to the SQL PROMPT toolbar? Or possibly as a hot key menu option?

    I switch styles often. There's the style I like to work in, a style suited for debugging, and the style that management likes the code to be posted with (in TFS.) Being able to switch between them is very helpful. but, going to SQL Prompt --> Options --> Styles --> Selecting Style "with the mouse" is time consuming.

    Thanks for your consideration!

    Lawrence Barnes

    10 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  ·  User interface  ·  Admin →
    completed  ·  Thomas Walsh responded

    We’ve released support for quick switching of active styles in version 8 of SQL Prompt. You can right click in the editor window, select `Active Style` and then choose the style you want to switch to.

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

    If you are still keen to have this functionality available via a hotkey, please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

  2. "d" in "order by" should prompt with "desc", not "dbcc"

    Currently if you type a query like this:

    select *
    from sys.objects o
    order by o.name d[CURSOR]

    the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.

    While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.

    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  ·  Intellisense  ·  Admin →

  3. Remove extra space between statements option is Needed

    SELECT
    *
    FROM
    Temp1

    --Remove this kind of extra spacing between statements option is Needed

    SELECT
    *
    FROM
    Temp2

    --Remove this kind of extra spacing between statements option is Needed

    SELECT
    *
    FROM
    Temp3

    10 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 →

  4. Remove Red Gate toolbar

    This is an old problem that just won't go away.

    The Red Gate toolbar that holds the SQL Prompt icons (Tab History, Add-ins, SQL Test, SQL Search) will not persist it's state in SSMS. You can move it, but it comes back to the same place on it's own row. You can delete it, but it comes back again.

    Recommend (a) making the toolbar's state persistent in SSMS and (b) added a feature to the Options menu that allows the user to remove it.

    Using SQL Prompt 6.4.0.678 on SSMS 11.0.5058.0 (2012).

    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

    7 comments  ·  User interface  ·  Admin →

  5. highlight all columns and filters for a table alias when that alias is selected

    when selecting a particular table alias, can you highlight all places where that alias is being used like in notepad++

    5 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  ·  Admin →

  6. Add 'N' to unicode type literal strings

    Hi,

    Is it possible to format below code

    DECLARE @a VARCHAR(200);
    SELECT @a = 'asdf';
    DECLARE @b NVARCHAR(200);
    SELECT @b = 'asdf';

    to

    DECLARE @a VARCHAR(200);
    SELECT @a = 'asdf';
    DECLARE @b NVARCHAR(200);
    SELECT @b = N'asdf';

    Thanks.

    16 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  ·  Andrei Rusitoru responded

    Hello,

    We have added this feature in SQL Prompt 9.1.4.4532
    It can be found under Prompt → Options → Style

    It currently only works with variable assignments for variables declared in the same script.

    If you would like to see us expand this more please let us know by creating a new idea.

    Kind Regards,
    The Prompt Team

  7. Auto complete/intellisense suggestions using PIVOT

    Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

    The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

    Ex:[code]CREATE TABLE dbo.tbTest(
    Id INT,
    foo VARCHAR(3),
    bar FLOAT
    )
    GO
    INSERT INTO dbo.tbTest
    VALUES (1, 'foo', 2)
    , (2, 'bar', 3)
    , (3, 'foo', 4)
    GO
    SELECT *
    FROM (
    SELECT *
    FROM dbo.tbTest AS tt
    ) pvt
    PIVOT (
    MAX(bar) FOR foo IN ([foo], [bar])
    )p
    [/code]…

    3 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  ·  Qualify object names  ·  Admin →

  8. Add Comment Block to Surround With choices

    Can you add a comment block /* */ to the Surround With choices? It would be of great use.

    I also like the idea of adding Surround With options to the snippet editor where one could specify the before and after.

    The example one person gave was Surround With ISNull( <highlighted column> ,0)

    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

    2 comments  ·  Admin →

  9. 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”

  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. Tab History (aka SQL Tab Magic) should not show currently open windows

    I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.

    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  ·  Tab history  ·  Admin →

  12. Tab Coloring

    Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.

    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

    3 comments  ·  Tab coloring  ·  Admin →

  13. Insert Statement Highlighting with Split-Screen

    Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.

    http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4223150-insert-statement-highlighting-column-and-value

    It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.

    To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).

    This new…

    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  ·  User interface  ·  Admin →

  14. Qualify Ojects in SQL (Add square brackets)

    When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:

    CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
    Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
    Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));

    3 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  ·  Format SQL  ·  Admin →

  15. Allow Alias Names to Conflict with Stored Procedure Names

    We have a table called SalesOrder. We also have stored procedures named so, so2, and so3. When SQL prompt creates the auto alias, it uses so4 because it won't create an alias using the name of an existing object.

    I would like the alias to use so. The aliases don't need to have unique names in cases where the name conflicts with the name of a stored procedure.

    If that's not possible or likely, then I would like SQL Prompt to use the custom alias defined for the table, even in cases where the name conflicts with a stored procedure.

    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  ·  Admin →

  16. qualify column names with table: temporary tables

    The qualify column names should work with temporary tables as well.

    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  ·  Qualify object names  ·  Admin →

  17. Add connection limit for restoring tabs

    Please add an option to ignore tabs over a certain number of connections.

    It would avoid long waits when SSMS starts if in the previous session I forget to close a one-time query against hundreds of servers.

    In its current implementation, SQL Prompt can crash SSMS before the connections complete.

    See SQL Prompt forum for context:
    http://www.red-gate.com/MessageBoard/viewtopic.php?p=71834

    3 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  ·  Tab history  ·  Admin →

  18. 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 →

  19. Retrieve BETA Updates when checking for updates

    I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
    Perhaps this could be an option for those that aren't interested in participating in betas.

    3 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  ·  Admin →
    completed  ·  Aaron Law responded

    SQL Prompt 7 now has a button to toggle beta updates on the check for updates dialog.

  20. Remove trailing spaces

    Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting

    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  ·  Format SQL  ·  Admin →
1 2 3 5 7 … 13 14
  • Don't see your idea?