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. $ISODATE$ placeholder in snippets

    The $DATE$ placeholder is great, but it inserts a date string according to my (or the server's?) locale.
    I would very much prefer a placeholder that always inserts the current date according to ISO 8601 (e.g. '2015-07-22').

    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

    2 comments  ·  Admin →

  2. Introduce the $CLIPBOARD$ placeholder

    I would love to see the $CLIPOARD$ placeholder, representing the current text contents of the system clipboard (if there is any text in it, obviously).

    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 →

  3. Don't indent BEGIN/END bloc after AS in function/procedure definition

    CREATE FUNCTION MyFunc()
    RETURNS INT
    AS
    BEGIN
    ----IF 1=1
    --------BEGIN
    ------------<some code>
    --------END
    END
    END

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

    This should already be an option in SQL Prompt under Format→Schema statements→Indent contents.

  4. SYSDATETIME() instead of GETDATE() as default value for datetime2 columns

    When generating an insert script with default values for a table, use SYSDATETIME() instead of GETDATE() for datetime2 columns. GETDATE(), is fine for datetime columns, but for datetime2 columns, which have a larger precision SYSDATETIME() would be more appropriate.

    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

    4 comments  ·  Admin →

  5. Copy column from grid results as comma separated list

    Oftentimes when I am writing queries, the results from one column of one query are quickly needed in my next one in an IN clause. I highlight the column of values from the results grid and paste into the query window, and then have to append commas (and for neatness, I delete the line breaks). I would be nice to have an added option the context-menu of the results grid to add a copy as comma separated list (in addition to the current copy and copy with headers options).

    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

    0 comments  ·  User interface  ·  Admin →

  6. semi colon placed on new line

    Place semi-colon on new line.

    I frequently format my statements as I'm developing them, but multiple times now I've started to add an Order By or some other clause after the auto-inserted semi-colon. I would like to see an option to place the semicolon on the line following the sql statement rather than directly after. This would enable me to start typing at the start of the next line without having to check if a semicolon had been added to the preceding line.

    Example:
    Select * From Table
    Where A = 1; -- Semicolon added by formatting
    Order By A

    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

    1 comment  ·  Format SQL  ·  Admin →

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

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

  9. try snippet

    It would be nice to have a TRY CATCH snippet.

    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 →

  10. Exclude Identity Field From Auto Generated Insert/Values Code For Table Variables

    If a table variable or temp table has an identity field, I do not think this field should show up in the auto generated insert into/values list:

    DECLARE @Table TABLE (TableId INT IDENTITY(1,1), Data VARCHAR(100);

    INSERT INTO @Table
    ( [TableId] -- This field show not show up by default in the insert list
    , [Data] )
    VALUES ( 0 -- TableId - int -> This field show not show up by default in the insert values list
    , '' -- Data - varchar(100)
    )

    -- Temp Table
    CREATE TABLE #Temp (TableId INT IDENTITY(1,1), Data1);

    INSERT INTO [#Temp] ([TableId],
    [Data1]) VALUES…

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

  11. Surround list of values with quotation marks and separate by commas

    when creating a WHERE colname IN ('a','b','c')

    it would be nice if you could paste a set of rows from excel into SSMS and then add the quotation marks and commas

    i.e.

    A
    B
    C

    becomes

    'A',
    'B',
    'C'

    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

    1 comment  ·  Format SQL  ·  Admin →

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

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

  14. IF statement format options

    Please provide the option to format IF statements as follows, based on the format settings sample.

    IF @productType IN ('a', 'b', 'd', 'g', 'i', 'O', 'Q', 'X', 'Z') BEGIN

    ----IF @cost <= @compareprice BEGIN

    --------PRINT 'Less than $' + CAST(@compareprice AS varchar(20))

    ----END ELSE BEGIN

    --------PRINT 'Exceeds $' + CAST(@compareprice AS varchar(20))

    ----END

    END

    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

    1 comment  ·  Format SQL  ·  Admin →

  15. Aggregate Functions wrongly put in square brackets

    I think I 've found a bug...
    If you Format this SQL

         DECLARE @Translations TABLE
        (
          [FundTypeId] INT NOT NULL ,
          [ColumnName] NVARCHAR(128) NULL ,
          [ColumnValue] NVARCHAR(256) NULL ,
          [InsertedAt] DATETIME NULL ,
          [InsertedBy] NVARCHAR(256) NULL ,
          [LastUpdatedAt] DATETIME NULL ,
          [LastUpdatedBy] NVARCHAR(256) NULL ,
          PRIMARY KEY ( [FundTypeId] )
        );

     SELECT *
     FROM   ( SELECT    [pt].[FundTypeId] ,
                        [pt].[FundType] ,
                        [pt].[Comment] ,
                        [pt].[InsertedAt] ,
                        [pt].[InsertedBy] ,
                        [pt].[LastUpdatedAt] ,
                        [pt].[LastUpdatedBy]
              FROM      @Translations AS [tmp] PIVOT ( MAX([ColumnValue]) FOR [tmp].[ColumnName] IN ( [FundType], [Comment] ) ) AS [pt]
            ) AS [tmp];

    ... it will break the code as the MAX function of…

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

  16. Add a menu option to decrypt stored procedures

    It would be useful to add an option to decrypt encrypted stored procedures and display the decrypted SQL in a query tab.
    We often work with encrypted SP's on customer databases, but when there is a bug report, it is often hard to see what is going wrong.

    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

    5 comments  ·  Admin →
    completed  ·  Aaron Law responded

    Hi Dirk,

    This is already available in the latest SQL Prompt. It’s on by default but just to double check it’s enabled for you, there’s a checkbox at the bottom of the behavior page in the options named “Decrypt encrypted objects”.

    Thanks,
    Aaron.

  17. Add wildcards to tab coloring

    Would be useful if tab coloring supported wildcards
    eg *.sql = production
    *.dev = development etc

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

    Hi Nigel,

    Wildcards are already supported for tab coloring in the latest version of Prompt. Just use a * for the wildcard in either the server or database column on the tab color options page. If you’re having any problems with this, please send me an email: aaron.law@red-gate.com

  18. Inserting the AS keyword for aliases

    It would be nice if one could click a button and get the AS keyword between an object name and its alias. This would help with code that doesn't use AS to separate the two. And would also help readability.

    Thanks.

    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

    1 comment  ·  Format SQL  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 7.3 of SQL Prompt.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

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

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