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

270 results found

  1. In Visual Studio 2010, when I type in a function name and then the open paranthesis, I'm shown some intellisense that tells me what type of parameters I need to type in. For example, if I type (using VB.Net) "Dim da as Date=DateAdd(", it tells me the first paramter is "Interval as Microsoft.VisualBasic.Interval", and so forth. It would be nice if SQL Prompt did this for built-in (or even user created) functions, e.g. the DATEADD SQL function. I can never remember exactly the parameter sequence of that function, and it would be nice if SQL Prompt showed me like VS…

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    completed  ·  Paul Stephenson responded

    SQL Prompt already did this, but there was a bug with certain built-in functions, including DATEADD(), that prevented the tooltip from appearing. This is now fixed in SQL Prompt 5.2.

  2. Add the ability to change the snippet file folder location so as to share snippets between users,or machines for the same user. Of course the change would also need to check the folder for new snippets on startup and at the request of the user, the latter being important for those of us who leave ssms running for long periods.

    23 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  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes the option to specify where snippets are stored.

  3. It would be nice, if the suggestions list for GROUP BY would include all the all the not aggregated SELECT list columns first.
    For ORDER BY, all the columns/aliases or their ordinal, and add checkbox for ASC/DESC.

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

  5. Right now, if I have

    Select * From TableA As ta
    Inner Join TableB as tb On ta.Key = tb.Key

    and I "Press TAB to expand wildcard" only the fields that are in common get qualified with the table aliases. I would like to see an option of ALWAYS having the table alias added even if there is only one table.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. In order for the braces/parenthesis highlighting to work currently, you must run the native Intellisense feature in SSMS, which creates some issues with SQL Prompt. If this were written in as part SQL Prompt, we'd be able to turn off Intellisense completely.

    51 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

    7 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)
  7. There appears to be several items (BEGIN and END tabbing, table declaration placement, number of tabs for the join condition...etc.) that happen automatically when you click Refactor that Format SQL that you can't configure in the UI.

    39 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)
  8. It would be nice if there was a way to import and export all SQL Prompt options like how you can import and export format styles.

    39 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)
  9. A wildcard search when
    select * from <tablename> now we only see table names starting with the key, but it would be very nice to have the exist in it as well.
    so tra -> will result in traffic but also mytraffic

    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  ·  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. When saving results from the grid in SSMS the only option is to csv. It doesn't include headers and if your data has commas in it, the csv file becomes formatted incorrectly. An option to go to excel, or a tab delimited txt file, or choosing the delimiter would be useful.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. It would be great if the Options-forms was resizable (and the formsize was stored when closing the form).

    The 'Sample SQL' textbox would then be larger so all SQL code is visible with the formatting options that are chosen.

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. In Format --> Tabs & Wrapping there is no option to keep and actual TAB character, instead a tab is converted to the user configurable number of spaces.

    This one is especially important for me because we have other code checking for TABS not (2,3,4,6,8) spaces. I now need to run a powershell script to convert the spaces back to a TAB.

    Would be great to allow TABS to remain as TABS.

    55 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  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes support for tabs.

  13. Would like improve tab & parenthesis placement of subqueries ...wherever placed in query ...be it in JOIN, WHERE, HAVING ...or even in SELECT ...ALSO would like option for 1st tabbed item in SELECT list to be the starting position on each row for each subsequent item which includess the placement of the 'prefixed' comma ...see below...

    BEFORE (Current formatting)...

    LEFT OUTER JOIN (
    SELECT
    f1
    , f2
    , f3
    FROM
    dbo.t1
    WHERE
    f9 = 'x'
    ) AS e
    ON e.f1 = b.f1
    AND e.f2 = b.f2

    AFTER...

    LEFT OUTER JOIN
    (
    SELECT
    f1
    , f2
    , f3
    FROM
    dbo.t1
    WHERE…

    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

    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)
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8.1 of SQL Prompt as part of our rework of parentheses formatting.

    If there are any missing features please let us know by creating a new suggestion.

    Kind Regards,
    The Prompt Team

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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. I would like to see an additional placeholder, maybe called $SUGGEST$, added to the snippets. This placeholder would position the cursor like $CURSOR$ and bring up the suggestions as if you hit CTRL-space. This would resolve an annoying issue that some of us see with our SSF snippet when we have a space after the FROM clause, and we are then required to hit CTRL-space to bring up the suggestion after expanding the snippet. (See forum post: http://www.red-gate.com/MessageBoard/viewtopic.php?t=12423)

    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)
    completed  ·  Paul Stephenson responded

    As of SQL Prompt 5.2.8, the suggestions list will pop up automatically after a snippet insertion — if it would be sensible to do so (e.g. if the list would normally pop up if you typed the snippet out by hand).

  16. using the example
    SELECT patientid FROM PTGEPATIENT AS pgp

    If I qualify object names (ctrl-B, ctrl-Q), I will get

    SELECT [pgp].[patientid] FROM [dbo].[PTGEPATIENT] AS pgp

    The alias is not enclosed in square brackets after the "AS" keyword. Would like to see that support for consistency (this is the standard I currently have in place)

    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)
  17. Request space options for semicolons that are analogous to space options for commas (see SQL Prompt-->Options-->Format-->Commas & parentheses)
    p.s. -I really don't like the current auto-insertion of a space in front of the semicolons. At the very least, the semicolon formatting should remain untouched upon running Format SQL.

    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

    3 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  ·  Paul Stephenson responded

    As of SQL Prompt 5.2.8, spaces are no longer inserted before semicolons during a Format SQL operation. We have not added a new option, as we have found no-one who likes the spaces to be there. If we receive further feedback to the contrary then we will consider adding an option in the future.

  18. I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
    Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for…

    102 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  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes full synonym support.

  19. 90 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

    25 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)
  20. Now that sql prompt and refactoring have been merged, how about a means of identifying where 'select ' has been used in stored procedures etc. including select a. and select bob, *
    I would have thought that you've already done the hard work, as SQL prompt already recognises these stars when it proposes to expand the column list.

    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

    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?