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

(thinking…)

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

279 results found

  1. RECEIVE statement - Format SQL ignores

    ;
    RECEIVE TOP(1)
    @h = conversationhandle,
    @t = message    typename,
    @b = message    body
    FROM SimpleQueueTarget

    From the Service Broker Workbench on Simple Talk.

    It only moves the semicolon to a separate line. No errors. Ignores "comma at start".

    And, yes, the @'s above probably start in column 1, when they're actually in col 5.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    completed  ·  Andrei Rusitoru responded

    This feature was released in version 8 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

  2. Add a menu option to decrypt stored procedures

    It would be useful to add an option to decrypt encrypted stored procedures and display the decrypted SQL in a query tab.
    We often work with encrypted SP's on customer databases, but when there is a bug report, it is often hard to see what is going wrong.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Admin →
    completed  ·  Aaron Law responded

    Hi Dirk,

    This is already available in the latest SQL Prompt. It’s on by default but just to double check it’s enabled for you, there’s a checkbox at the bottom of the behavior page in the options named “Decrypt encrypted objects”.

    Thanks,
    Aaron.

  3. Add support for SQL CMD variables in SSDT/VisualStudio

    When using SQL CMD variables in VisualStudio/SSDT project to support Database references using a Database variable(ex Different database, same server). SQL Prompt is no longer able to resolve objects.

    SELECT a.* FROM [$(RefDataBase)].[dbo].[MyTable] a
    Then a becomes an "unresolved alias"

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →

  4. "d" in "order by" should prompt with "desc", not "dbcc"

    Currently if you type a query like this:

    select *
    from sys.objects o
    order by o.name d[CURSOR]

    the popup consists of dbcc, deallocate, declare, delete, deny, desc, disable trigger, drop, dump.

    While that is probably technically accurate, it would be much more helpful to make "desc" the first entry in the list, because it's what I'm typing 100% of the time.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Intellisense  ·  Admin →

  5. Insert Statement Highlighting with Split-Screen

    Excellent work by the team in SQL Prompt 6.4 implementing the "Insert Statement Highlighting Column and Value" feature.

    http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/4223150-insert-statement-highlighting-column-and-value

    It would be great if this could be tweaked to work with split-screen editing. For example, if you have a REAAALLLY wide table, you might want to have your editing cursor in the bottom pane of SSMS but be looking at the top pane.

    To clarify, I am talking about allowing the highlighting to work in both the top and bottom panes if you enable Window... Split (or drag the thing down at the top of the scroll bar).

    This new…

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  User interface  ·  Admin →

  6. Allow Alias Names to Conflict with Stored Procedure Names

    We have a table called SalesOrder. We also have stored procedures named so, so2, and so3. When SQL prompt creates the auto alias, it uses so4 because it won't create an alias using the name of an existing object.

    I would like the alias to use so. The aliases don't need to have unique names in cases where the name conflicts with the name of a stored procedure.

    If that's not possible or likely, then I would like SQL Prompt to use the custom alias defined for the table, even in cases where the name conflicts with a stored procedure.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Admin →

  7. Set to off "Restore open tabs when SQL Server Managerment Studio starts"

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  1 comment  ·  Tab history  ·  Admin →

  8. Dot insertion key breaks IP addresses in Linked Servers

    I added the 'dot' option to insertion keys and now I am unable to type dots in an IP address for a linked server without it autocompleting some random address, which I then have to go back and correct.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →

  9. sort

    It would be nice to have sortable columns in the table popup. This way we can see them in ordinal order (as it exists now), or order them alphabetically (or even by data type). Hopefully not much harder than changing a grid column property.
    This would make it much easier for our Oracle folks to accept using SSMS, as it seems all Oracle tools do this by default. It would also shut them up. :) :)

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Admin →

  10. Format "case" keyword also in uppercase

    When formatting a case statement I want the case keyword to show in uppercase just like the when and end keywords. Now initially it uppercases CASE but when running SQL format it turns it to lowercase (bug?) See example below of the current format behaviour.

    SELECT case WHEN 1 = 1 THEN 1
    ELSE 0
    END

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →

  11. Incorrect capitalization of system functions

    The SQL Prompt formatter incorrectly tries to capitalize (whether automatically while I type or using the formatter) system functions that are missing a database prefix. For example, SQL Prompt doesn't try to capitalize:

    sys.fn_listextendedproperty

    but it WILL capitalize

    fn_listextendedproperty

    as soon as I hit space, regardless of the CASE setting in SQL Prompt's options. Obvious, a capitalized FN_LISTEXTENDEDPROPERTY does not work: the function is case-sensitive.

    There does not appear to be a way around this, not even by setting Format -> Styles -> Case -> Buit-in functions to "Leave as is". That only resolves the problem for the manual formatter:…

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    completed  ·  Aaron Law responded

    This is fixed in the latest build of Prompt, if you’re still having problems please let me know.

  12. Case formatting

    Case formatting to allow option of capitalising initial letter only - e.g. Select, not SELECT or select.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Admin →
    completed  ·  Aaron Law responded

    The latest version of Prompt has the casing option UpperCamelCase which will case SELECT as Select.

  13. Tab Magic EAP hijacks CTRL-T completely.

    Do not hijack CTRL-T in Tab Magic. I routinely use this to direct query output to Text. I use this in concert with CTRL-D, for output to Grid.
    Perhaps when options for Tab Magic are provided, we will be able to turn off this feature.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Admin →
    completed  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes the ability to change the keyboard shortcut.

  14. Show Long file names in Query History in Tool Tip

    Hi,

    Thanks for your last changes!

    In addition, I have sometime Long file names where only looking on their Name tail or according to their full path, I can decide which one is the relevant.
    Could you add in Query History a Tool Tip when hovering above the File Name with Full Name, Path, Last Closed, Last Connection details, etc.?

    THNX
    Jermy

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Admin →

  15. Recognize double quotes for object names in the same way as square brackets.

    Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.

    For example, typing:
    SELECT * FROM [MyTable]
    will allow the expansion of the asterisk, while
    SELECT * FROM "MyTable"
    does not.

    SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Qualify object names  ·  Admin →

  16. auto suggest when character is added after table is selected so when SalesOrderLine is shows after SalesOrder

    Intellisense should pop up when a character is added after table is selected so when there is a table named SalesOrderLine it should be suggested even after the table SalesOrder was chosen via tab if i type further without a space.

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →
    completed  ·  Aaron Law responded

    The latest version of SQL Prompt (6.3) should show the suggestions again once you type the “L” after SalesOrder

  17. Please provide intellisense even when not in the current database

    In SSMS when accessing a table that is not in the current database (using the three part convention) then no intellisense is coming up for the fields (such as in the where clause)

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →
    completed  ·  Thomas Walsh responded

    SQL Prompt now supports suggestions from other databases when using the three part convention.

    Kind Regards,

    The Prompt Team

  18. Supprt Quoted identifiers for prompting

    If you go
    SELECT * FROM sys.tables AS t
    or
    SELECT * FROM sys.tables AS [t]

    then intellisense will happily carry on working correcly, with t. now showing object members.

    However

    SELECT * FROM sys.tables AS "t"
    and
    SELECT * FROM sys.tables AS 't'

    both cause the intellisense to give up for the rest of the batch. All four identifier markups are valid (for now) and should be treated equally...

    1 vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Admin →

  19. More options for saving results from grid

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

    We’ll send you updates on this idea

    0 comments  ·  Admin →
1 2 … 10 11 12 14 Next →
  • Don't see your idea?