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

13 results found

  1. After I type
    SELECT * FROM sys.indexes i
    INNER JOIN sys.partitions p
    ON i.indexid = p.indexid
    AND

    the IntelliSense still suggests me i.indexid = p.indexid which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining

    26 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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

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

    Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.

    Please feel free to send us any additional feedback on these topics by commenting here.

    Kind Regards,
    The Prompt Team

  2. The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking

    For Example,

    User types:
    SELECT Master.Active,

    Prompt now makes it

    SELECT m.Active -- Cursor stays here
    FROM Master m

    We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.

    Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.

    This feature is also more natural to find because the developer…

    19 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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

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

    Currently, we have no plans to implement this feature in the near future. However, if there is sufficient demand in the future, we will revisit it.

    Please feel free to send us any additional feedback on these topics by commenting here.

    Kind Regards,
    The Prompt Team

  3. Allow starting a query with the FROM clause (ala LINQ) and provide intellisense normally. I would continue normally, right up to the point the user types the select update or delete keywords, at which point you either automagically reposition the keword and cursor to the top of the query, or allow the user to finish and then prompt for query restructuring. This would completely do away with the mucking around of doing a ssf and then going back later to fill in the list! In fact, I'd take it a step further and offer to restructure poorly written queries..e.g., If…

    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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  4. Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.

    eg.

    Customer = C
    mem_Membership = M

    cus_StateCustomer = SC

    aReallyLongTableName = RLTN

    view_CustomerMembership = CM

    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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  5. When you have a table in a FROM clause that is aliased, but the table doesn't exist, or is a temp table where the creation isn't in the script or is commented out SQL Prompt doesn't even include the alias as a suggestion. I think it should.

    You can see my example in this forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=46775#46775

    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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  6. Often we'll do a query e.g. SELECT Id from Table where param LIKE '%Foo%'

    Then we'll want to copy and paste those Ids in to a separate query

    DELETE FROM Table WHERE Id in (.......)

    It would be good if there was a way SQL Prompt could help format the clipboard paste into a comma-separated list.

    (I appreciate this example would be simple to refactor as a JOIN)

    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 →
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

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

    Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.

    Kind Regards,
    The Prompt Team

  7. I would like to get suggestions for the WHERE query value. For example, when querying a dimension table, I would like to receive a selection box with the possible values to enter.

    empid firstname lastname


    1 Test User

    2 Dummy User

    Select * from Table
    Where firstname= [Suggestion Box displays the values "Test" and "Dummy" to pick]

    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 →
    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

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

    Currently, we have no plans to implement this feature in the near future, as it does not align with our current work.

    Kind Regards,
    The Prompt Team

  8. When we right-click a table in the object explorer and choose "Edit top 200 rows" (SS2008 onwards), the SQL editor is not the T-SQL script editor so SQL Prompt is unavailable. It would prove VERY helpful to have full SQL Prompt "Suggestions" functionality available.

    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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  9. The intellisense will suggest the object as I am typing the linkedserver.db.schema.table in a statement. However, once the statement has been created, the object/columns etc. are underlined in red and hovering over displays the "Invalid object" warning

    2 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. Track how often columns are joined by the user, and suggest based on common joins (for that user), not just foreign key/name/datatypes.

    2 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

    declined  ·  Thomas Walsh responded

    Thank you for your suggestion.

    Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.

    If you feel strongly about it, we encourage you to create a new request.

    Thanks,

    The Prompt Team

  11. SQL Prompt code completion is broken if you use the OPTION ( USE HINT ( ) ) syntax with an update query. To make matters worse, if you are writing a stored procedure, the code completion tools remain broken for every query following the UPDATE statement as well.

    This is on SQL Prompt v9.4.15.8960 with SQL Server Management Studio v17.9.1.

    Here is a repro:
    CREATE OR ALTER PROCEDURE dbo.TestThis
    AS
    BEGIN
    SET NOCOUNT ON;

    DECLARE @var int;

    -- try to do any code completion after this statement
    -- only snippets will work
    UPDATE TestTable
    SET WatchThisBreak = 1
    OPTION( USE…

    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

    declined  ·  1 comment  ·  Intellisense  ·  Admin →
  12. sometimes its counter productive, messing up in the way of regular intellisense

    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

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

    Hi Anvoy,

    Sorry to hear you’re having issues with SQL Prompt! This sounds more like a bug than a feature request so I’m going to close this idea – our support site would be a better place to log it: https://redgatesupport.zendesk.com/hc/en-us/requests/new
    please include the version of SQL Prompt that you’re using and detailed recreation steps.

    Thanks,
    Aaron.

  13. WIth the change in v6 to default to

    SELECT * FROM table1
    INNER JOIN table2
    ON table2.id = table1.id

    whereas previous versions used this format.

    SELECT * FROM table1
    INNER JOIN table2
    ON table1.id = table2.id

    If upgrading from an earlier version, can either the swap order option be enabled or at least the user warned during installation that the intellisense options have changed and that queries will be formatted differently.

    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

    declined  ·  Aaron Law responded

    Thanks for your suggestion Kieron.

    In adding this new option, we set the default column order to what we think will be the most useful. If you prefer the old behaviour, select the new option – your option preferences will be persisted when you install new versions of SQL Prompt.

  • Don't see your idea?