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.

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
  1. code folding

    Enabled Intellisense conflicts with SQL Prompt and needs to be disabled. This also disables Code Folding feature (Outline Statements) of SSMS, which is very useful for large coding projects.
    It would be helpful if SQL Prompt were to offer the similar feature.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  2. Ignore SQL Snippets that match table alias

    Sometimes SQL Prompt generates an alias that matches an existing snippet key. My suggestion would be to ignore snippets when it's an auto generated alias.
    example:
    select * from DataEnvironment de (where de is the automatic alias) becomes
    select * from DataEnvironment DELETE

    It's rather annoying :)

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  3. List aggregate functions before system fields

    When putting a COUNT in a select field, the default option in intellisense is sysxmitbody.count. I understand if I have a field that contains the aggregate name in my table that you suggest it first, but I never want sysxmitbody.count - and if I do, I'd expect to go looking for it.

    I feel like I've hit this problem with other aggregates as well, but can't find another example at the moment.

    Not sure the best fix, maybe list all system tables after user tables and functions?

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  4. Autocomplete stored procedure using local time zone on datetime arguments.

    When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the *local time zone*.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  5. Autocomplete stored procedure using local time zone on datetime arguments.

    When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the *local time zone*.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  6. Control the behaviour of SQL Prompt insertion

    I would like the ability to control how SQL Prompt completes my statements for me, this mostly becomes an issue with procedures with multiple optional parameters.

    If I used sp_whoisactive as an example, there are multiple optional parameters but it is capable of running with no parameters at all, so I find myself having to spend longer than I want to either highlighting the bit I want execute or deleting all the parameters that just got written for me.

    So a setting where I can assign keys to complete full statement and keys to simply complete object name would be…

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  7. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  8. Autocomplete WHERE clauses with variables

    It would be neat if WHERE clauses could get autocomplete suggestions with declared variables (or variables that are procedure parameters). Example:

    Assume Table1 with one column Column1.

    DECLARE @Column1
    SELECT *
    FROM Table1 T
    WHERE T.Column1 = (suggest @Column1, any variable that exactly matches column by name, except @)

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  9. SQL AUTO-SYNTAX

    when you insert a ssf (Select * from) you select the table and correct automatically errors like WEHRE, WERE, WEHER where the user wants to say a WHERE a logical word dictionary in which, it could be done by matching characters if all the characters written are 100% or 90% matches with word WHERE whenever is the order of the characters then autochange the text for where, This also can be matched with other KEYWORDS of SQL

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  10. Code Analysis Disable Rule for specific cases

    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.

    9 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  11. Detect the database compatibility version

    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.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  12. Discover metadata for OPENQUERY

    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.

    5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  13. MS_Description supporting hyperlink when SQL Prompt is showing the tooltip

    I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MS_Description 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. MS_DescriptionRedGate) below the MS_Description which is containing a hyperllink and this is then shown under…

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  14. Use icon to denote fields with indexes

    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 "inserted_time" vs "post_time" 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 why not…

    14 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  15. Autocomplete stored procedure With DEFAULT Values

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

    15 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  16. when aggregating add alias

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

    9 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  17. Pin feature for quick info

    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.

    7 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.

    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.

    11 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  19. Load suggestions from sql files in Visual Studio/SSDT Projects

    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.

    72 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    15 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →

    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

  20. Please include support for Extended Events in SQL Prompt

    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

    12 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base