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

80 results found

  1. RECEIVE statement - Format SQL ignores

    ;
    RECEIVE TOP(1)
    @h = conversationhandle,
    @t = message    typename,
    @b = message    body
    FROM SimpleQueueTarget

    From the Service Broker Workbench on Simple Talk.

    It only moves the semicolon to a separate line. No errors. Ignores "comma at start".

    And, yes, the @'s above probably start in column 1, when they're actually in col 5.

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

    This feature was released in version 8 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

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

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

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

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

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

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

  8. Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1

    We have a lot of legacy code that is written as

    SELECT Field1 as Name1, Field2 Name2 FROM Table X
    (Sometimes they use AS when setting the alias, othertimes they do not).

    I would love the ability to convert this to
    SELECT
    Name1 = X.Field1
    , Name2 = X.Field2
    FROM Table X

    Both having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.

    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

    6 comments  ·  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

  9. Highlight --TODO and --HACK comments

    When a --#TODO: or --#HACK is written on our code, it could be helpful to highlight it in order to give an alert to the reader. In addition it can be very helpful to let the user to configure the pattern (i.e. --#MyTerm).

    46 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 →
    completed  ·  Thomas Walsh responded

    We’ve released support for highlighting TODOs in version 9 of SQL Prompt as part of its new code analysis feature.

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

    We’re marking this request as completed, but if you feel strongly about being able to configure the term, please feel free to open a new suggestion.

    Kind regards,

    The Prompt Team

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

  11. Add brackets to all database objects

    Similar to the existing Qualify Object Names and the other pending request to fix case of all object names, I would like to have an option to add brackets added to all database object names (columns, tables, schemas) where they are missing.

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

  12. Format "case" keyword also in uppercase

    When formatting a case statement I want the case keyword to show in uppercase just like the when and end keywords. Now initially it uppercases CASE but when running SQL format it turns it to lowercase (bug?) See example below of the current format behaviour.

    SELECT case WHEN 1 = 1 THEN 1
    ELSE 0
    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

    0 comments  ·  Format SQL  ·  Admin →

  13. Formating create table command

    Currently when formatting a Create table command the SQL Prompt is moving the "Default" to a next line and indenting it...
    like this
    [insertDT] DATETIME NULL
    [______INDENT] DEFAULT GETDATE()
    ,[ActualMU] INT NULL
    [    ___INDENT]DEFAULT 0
    ,[PlannedMu] INT NULL
    [    ___INDENT]DEFAULT 0
    ,[CompletedDT] DATETIME NULL
    [    ___INDENT___] DEFAULT GETDATE()

    And the format that I would like to see (making easier to read) is
    keeping all definition of each field in the same line, like

    ,[insertDT] DATETIME NULL DEFAULT GETDATE()
    ,[ActualMU] INT NULL DEFAULT 0
    ,[PlannedMu] INT NULL DEFAULT 0
    ,[CompletedDT] DATETIME NULL DEFAULT…

    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  ·  Format SQL  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

  14. Incorrect capitalization of system functions

    The SQL Prompt formatter incorrectly tries to capitalize (whether automatically while I type or using the formatter) system functions that are missing a database prefix. For example, SQL Prompt doesn't try to capitalize:

    sys.fn_listextendedproperty

    but it WILL capitalize

    fn_listextendedproperty

    as soon as I hit space, regardless of the CASE setting in SQL Prompt's options. Obvious, a capitalized FN_LISTEXTENDEDPROPERTY does not work: the function is case-sensitive.

    There does not appear to be a way around this, not even by setting Format -> Styles -> Case -> Buit-in functions to "Leave as is". That only resolves the problem for the manual formatter:…

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

    This is fixed in the latest build of Prompt, if you’re still having problems please let me know.

  15. Stop auto Uppercase conversion of keywords in comments

    When a word is entered in a comment block, that is the same as a keyword (e.g. FROM), SQL Prompt should not automatically convert the word to uppercase.

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

  16. Support a common intending option for SELECT

    Sample query (spaces marked with underscores):

    SELECTstaffId, staffName, a
    FROM    __personnel

    SELECT and FROM have whitespace after them to align the rest of the statement. This formatting style is tedious to maintain and almost nowhere to be found in real codebases or on the web. Please support the more common code style:

    SELECTstaffId, staffName, a
    FROM    personnel

    Just one space.

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

  17. Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.

    Its a very nice tool who made developer life very easy and do a major and boring task of code formatting by just pressing CTRL+K+Y.
    i need a feature who can help developer very much like 1)If there is a SQL Insert query and i select a field it should highlight the value assigned to that selected field because finding this become more painful in formatted code.

    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

    0 comments  ·  Format SQL  ·  Admin →

  18. Case formatting

    Case formatting to allow option of capitalising initial letter only - e.g. Select, not SELECT or select.

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

    The latest version of Prompt has the casing option UpperCamelCase which will case SELECT as Select.

  19. Option to unformat onto a single line

    Often when I'm debugging code that dynamically generates SQL, I hit a breakpoint, then copy the code into an SSMS query window. All the code is typically in a single long line. I can then use SQLPrompt to format the code to read it, and potentially change it to correct errors. However, what I then often want to do is to paste the changed code back into the variable (or whatever). I'd love to be able to have an option to format the code all into a single line.

    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

    0 comments  ·  Format SQL  ·  Admin →

  20. Option to align AND predicates with WHERE

    Would love to be able to have all predicates at the same indent level ie:

    WHERE something = yetsomethingelse
    AND somethingelse = anotherthing

    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 →
2 4
  • Don't see your idea?