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

63 results found

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

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

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

  6. When using default values for INSERT can you display GETDATE() instead of getting the current date and displaying that?

    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  ·  Intellisense  ·  Admin →
  7. I really like the new feature in 6 that allows Ctrl-C to work to copy sections of scripts. However, I am missing an easy way to copy the entire script from the code pop-up. The copy button use to do this when nothing was selected in the pop-up window. Restoring this functionality would be appreciated.

    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

    completed  ·  Aaron Law responded

    SQL Prompt 6.1 has now been released and has the copy button returned to the popup.

  8. Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.

    Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway…

    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

    completed  ·  Alicja Leszczynska responded

    Hello,

    We added this feature recently (in SQL Prompt 9.1.0.4138).

    Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….

    Let me know if you find it helpful.

    Kind regards,
    Alicja

  9. Enhance snippets to support arbitrary fields like Visual Studio or SSMS 2012.
    So say I had the following snippet "dups" defined
    SELECT *
    FROM $tablename$
    WHERE $columnname$ IN
    (
    SELECT $columnname$
    FROM $tablename$
    GROUP BY $columnname$
    HAVING COUNT(*) > 1
    );
    I would type dups{tab}mytable{tab}mycolumn{enter}

    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

  10. Need Intellisense for the spatial functions and geography/geometry data types, especially since they are case sensitive, and annoyingly a mixture of upper and lowercase.

    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

    1 comment  ·  Intellisense  ·  Admin →
  11. When object names appear in the candidate window for an autocomplete, the schemas are not shown by default. Clicking on the the arrow in the bottom left of the window will show them, but this setting is not remembered so you have to do it each time. Also there's no keyboard shortcut that I can find to do this. Add the ability to set this popup to show the schema names by default.

    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

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

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

    completed  ·  Aaron Law responded

    We’ve just released SQL Prompt 6.1 which shouldn’t slow down SSMS with huge scripts.

  14. When a column is defined as rowversion or timestamp, please automatically exclude it from insert table column list.

    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

  15. The suggestions list after the TRIGGER is full of triggers. SQL Prompt, having been given the schema and table should narrow that list to only those present on the table to be ALTERed.

    I would categorize this as a bug, rather than a suggestion...

    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

    1 comment  ·  Intellisense  ·  Admin →
  16. Or maybe an option to disable parsing of statements using CTEs. My keyboard takes seconds to respond when several CTEs are in the script.

    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

    1 comment  ·  Intellisense  ·  Admin →
    completed  ·  Aaron Law responded

    We’ve just released SQL Prompt 6.1 which shouldn’t slow down typing when CTEs are used

  17. Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.

    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

    Many thanks for your useful feedback on this issue.

    We’ve done some further work on this feature that should hopefully address your issues. This has just been released in SQL Prompt v9.4.11 (available from https://www.red-gate.com/products/sql-development/sql-prompt/).

    The popups will now only go transparent after holding the Ctrl key for a short period instead of immediately. This should mitigate the issue somewhat. In addition, there is a new option (in Suggestions → Behavior → Make popups transparent when the Ctrl key is held down) to turn the feature off if it is not wanted.

    Kind regards,

    The Prompt Team

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

  19. 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 →
  20. It would be nice to be able to extend the intellisense matching to skip things like underscores. For example, if the table was called cardpickupstaging, you could match it with pickupstaging or upstag.

    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

  • Don't see your idea?