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

268 results found

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

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

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

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  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. 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)

    We’ll send you updates on this idea

    4 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Intellisense should find snippets where characters appear anywhere in the snippet name, not just at the beginning. I have 2 or 3 dozen snippets and I can't always remember what the less frequently used snippets are called. For example I might several snippets that deal with space usage, but some are named like this: "getSpaceUsage". It would be useful if typing "space" found all snippets that contained space anywhere in the name not just at the beginning.

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. 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)

    We’ll send you updates on this idea

    completed  ·  5 comments  ·  Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. The SQL formatter was one of the reasons we chose to buy the Developer Toolkit, but it doesn't seem to be able to be configured to format to our company style.

    An example of the style is here: http://pastebin.com/LTLRJ6Fb

    Notably, it would be good to be able to have the FROM and table name on the same line without excess white-space in between,

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

  8. Currently any comments that appear before the ALTER PROC statement are not scripted by SQL Prompt which results in those comments being silently deleted if the alter statement is executed.

    If I hover the mouse over a stored procedure name and click on the procedure name that pops up in order to see the script window I can see these comments but if I type alter proc <procname> and press tab to produce an alter script these comments are missing.

    There is a danger here of losing comments without the user being aware of it. I think SQL Prompt should…

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  10. After upgrading to SQL Prompt 6 (6.1), I notice reduced performance and I occasionally get "SQL Prompt cannot retrieve objects from <some database name>. (etc)", which reference a database that I do not use or am ever likely to use and IIRC have never used. It seems SQL Prompt is trying to cache objects for all databases on the connected server. That would be overkill, and only serves to slow it down and cause errors such as the one mentioned.

    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

    1 comment  ·  Intellisense  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Aaron Law responded

    This was likely due to the synonym support added in 6 which will try to offer suggestions by loading databases that the synonyms are referencing. In the latest build of Prompt this is optional (under Suggestions→Connections) and off by default.

  11. Typically, the GROUP BY column list is exactly the same as the SELECT list except the aggregates and any constants included. I usually wind up using a copy & paste, which is always a hassle, especially if it is a complex query. It always seemed to me that the GROUP BY list should be optional in the SQL standard. But short of a standard change followed by implementation changes, it would be nice to at least have it defaulted for me.

    By the same token, the HAVING statement could (optionally) prepopulate with (one of) the aggregate(s) from the select list.…

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Aaron Law responded

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

  13. I used to have a couple hundred milliseconds of delay in here. This was really helpful in some circumstances to allow me to do down a line of text adding tabs, spaces, commas, etc. (all kinds of things to satisfy my obsessive need for proper formatting). Without this option I now have to hit [ESC] each time to clear the suggestion box no matter how quick I move down, making this an annoyance.

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

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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)

    We’ll send you updates on this idea

    3 comments  ·  Format SQL  ·  Admin →
    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 have been sent a large database schema create script from a legacy system.

    The schema has been written in a case insensitive way.
    So for example any variables in the stored procs in this create script have been written in multiple cases:
    @pvariableNameOne
    @p
    variablenameOne
    @pvariablenameOne
    @p
    VariablenameOne
    etc....

    The database was originally hosted on a Latin1GeneralCIAS Collation at server and database level.
    The new hosting environment has been set to Latin1
    GeneralCSAS at server level, making it case sensitive.
    Although we can set the database to Latin1GeneralCI_AS to make…

    10 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

    1 comment  ·  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. 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)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. When typing a GRANT statement I no longer suggestions after the "TO" for domain users or groups that exist in the database. I only get SQL Users.

    Please include all users in "Security\Users" after the "TO" in the GRANT statement intellisense.

    4 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

    1 comment  ·  Intellisense  ·  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. It would be really nice to have a smart rename for aliases.
    Example:

    select c.ID, c.Name, a.*
    from Customers as c
    join Adress as a on c.adressid = a.adressid

    Usage: I select alias "c", click right mouse(or shortcut) and choose Smart Rename and the new aliase should be changed everywhere I use it.

    9 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

    1 comment  ·  Smart rename  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. 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)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Aaron Law responded

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

  • Don't see your idea?