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

269 results found

  1. Display the scale and precision (length) of data types like numeric and varchar in pop-up hint windows. This would be a very helpful feature to keep data types consistent throughout a database if one doesn't want to set up a user data type for each and every column that stores data types with additional parameters like, for instance, the scale and precision.

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

  2. The auto-generated INSERT statement BADLY MISALIGNS data when "Place commas at start" is enabled. I've listed all the settings to reproduce the issue at the end of this post.

    The comma and associated info are on a separate line (almost useless - Worse when I need to delete some of the columns). See this example (generated by SQL Prompt Pro 5.1 - hyphens represent tabs due to HTML limitations):

    INSERT INTO dbo.Test
    ---- (FirstName
    ---- , LastName
    ---- , LocationAddress
    ---- , LocationCity
    ---- , LocationState
    ---- , LocationZip)
    VALUES (''
    ---- , -- FirstName - varchar(100)
    ---- ''
    ----…

    11 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

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

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

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

    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)
  5. 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)
  6. When using a variable of a user defined table type, make intellisense smart enough to recognize the data type and provide the columns similar to if it were an actual table.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. Small suggestion, but I would find this useful!

    When hovering over a column you get a balloon that states:

    [Table Name].[Column Name] [Data Type] (column)

    If this could include 'NULL' or 'NOT NULL' this would be super :-)
    Possibily even more, such as default values or identity status?

    [Table Name].[Column Name] [Data Type] [NULL/NOT NULL] (column)

    SQL Prompt is an excellent bit of kit, top work guys!

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. If I have already typed in the alias name for a table, then suggestions after a period should always have the column names at the top. Sometimes, a code snippet shortcut or other unrelated item pops to the top of the list.

    For example, if I am have typed in:

    SELECT * FROM [sys].[tables] AS T
    WHERE [T].is

    Then, the snippet for INFORMATIONSCHEMA shows at the top of the list. Since I already have put [T]., it should have the column names such as ismerged_published, etc. at the top of the list.

    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  ·  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)
  9. Really like snippets, but sometimes I'd prefer to add a snippet by looking through the list of those available.

    Snippet shortcuts work well for things I do all the time, but I'd like to be able to use it as a repository for useful sql, and would therefore like a different way to insert, ie, via right click menu or even from the menu bar.

    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

    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 made several improvements to snippets including new insertion options.

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

    Here is the documentation for how to insert snippets using the various available methods: https://documentation.red-gate.com/sp9/speeding-up-your-queries/inserting-snippets

    If there is something missing please let us know by opening a new suggestion.

    Kind regards,

    The Prompt Team

  10. I'd like to vote for adding ST008 (non-named parameter style used) to the issues which can be auto-fixed. Hopefully it would be fairly simple to implement.

    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

    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

    Hi,

    We’ve released this autofix in SQL Prompt 9.5.13.11024. Please let us know what you think!

    Thanks,

    The Prompt Team

  11. I want to switch between TEAM and PERSONAL styles for Format SQL. It currently takes 8 mouse clicks to achieve this. Could you add a style lookup on the context menu or Red Gate tools menu and apply the style to the current document automatically as soon as it is selected.

    I want my team to be able to work in their personal SQL format, but always save in the TEAM format.

    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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

  15. 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)
  16. 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)
  17. 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)

    We’ll send you updates on this idea

    1 comment  ·  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. Provide an option to not indent the FROM and WHERE clauses to remain them lined up with the SELECT clause while maintaining a single space after each clause.

    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

    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)
  19. 2012 keywords like LEAD( LAG( etc.

    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

    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

    We’ve released SQL Prompt 6 which includes support for 2012 analytic functions (LEAD, LAG, CUME_DIST, etc)

  20. Intellisense does not seem to recognize variables declared within the current stored proc. This would be helpful.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?