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

76 results found

  1. Hi,

    it would be extremely useful to allow the user to disable a code analysis rule for specific cases and not just on a global scope.

    E.g.
    cast(cast(0 as binary) pops up the issue BP008 (CAST/CONVERT to var types without length) which my be correct for certain cases but not always.

    It would be very hand if I could tell the analyzer to not give any warning for this single line, perhaps by adding a pseudo comment like --##BP008 or similar.

    This comment would temporarily disable the warning for this single line/case but not for the rest of a script.

    15 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)
  2. When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split

    SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.

    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)
  3. When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.

    My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.

    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)
  4. I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MSDescription is a pain as it cannot be shown correctly in the appearing tooltip text.
    A nice Feature would be that I'm able to add a Hyperlink in the MS
    Description which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
    Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MSDescriptionRedGate) below the MSDescription which is containing a hyperllink and this…

    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 the drop down appears with field names (like when you're typing in a WHERE clause), include a little icon for each field that's the first field in an index (like the key pic when it's the PK).

    Being able to say "oh, that one has an index" would help me when trying to figure out how I want to filter things. (aka use "insertedtime" vs "posttime" vs the "start_time"). I'd say to use one icon (maybe greyed out) for non-clustered, and a different (or not greyed-out) icon for the clustered. You already include the field size, so…

    16 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)
  6. When autocompleting a stored procedure statement in the format 'EXEC storedProc @param1 = 0, @param2 0' it would really help if the parameters would initially have the default values defined in the stored procedure (if applicable).

    21 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. when doing simple aggregation such as sum(column), it would be nice if the column name would be aliased after the agg automatically. if this is a single column in the function then make the alias the column name. when multiple then create square brackets and move cursor into bracket after closing agg with a ")"

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.

    My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.

    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

    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. What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.

    12 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)
  10. Work at a company where we're adopting PDW. It would be great if I could get intellisense in PDW.

    61 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)
  11. Prompt currently needs a database connection to retrieve objects/suggestions from, which it gets from a database project's "Target Connection String".

    It would be better if prompt loaded suggestions directly from the sql files in the project without needing the database.

    105 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)
    Thomas Walsh responded

    Thank you for your suggestion.

    We’ve reviewed this as part of our UserVoice triage.

    Due to a lack of recent interest in this request, we are no longer actively reviewing it and have removed it’s “Under Review” status.

    If you feel strongly about having this feature added to Prompt, please continue to vote for and comment on this request.

    Kind Regards,
    The Prompt Team

  12. Extended Events is a great feature in SQL Server. Without support for this in SQL Prompt makes it incomplete.
    I know we have a GUI for it in SQL Server 2012. But it will quite sometime before everybody is on the latest version of SQL Server

    14 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)
  13. I really like auto quote completion, but when I am working with an openquery statement or dynamic sql where I am having to escape quotes by doubling them up, I find myself fighting the "helpful" behavior of quote completion either refusing to add a second quote or it adds too many quotes.
    So, my suggestion is that the quote completion feature check to see if you are trying to add quotes within a quoted string and change its behavior to either not do quote completion or to (even better) automatically add escaped quotes.

    To illustrate the problem and my proposed…

    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)
  14. Spell check on comments would be a nice addition to SQL Prompt. I know there can be misspellings within variables, table or any type of SQL object, but to at least have it in the comments would be nice.

    24 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)
  15. When I find I want to define my own table Alias within SQL Prompt, I must go to the menu, click SQL Prompt, scan down for "Options", scan down for "Aliases", click "New" and then do something useful.

    Please obviate ALL THIS, by giving a right-click fastpath to "Add Alias" while in the script editor. If the table name happens to already exist, please position the list at it (just in case SQL Prompt had issues...)

    It is very laborious to have to navigate through all these clicks just to add an alias while in the code.

    17 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)
  16. If I am running an "ALTER" or "CREATE" or "DROP", etc. Have SQL Prompt automatically refresh suggestions after my call.

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