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

269 results found

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

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

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

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

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  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  ·  Aaron Law responded

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

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

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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)

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

    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

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

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

    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

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

    Kind Regards,

    The Prompt Team

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

    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. 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)
1 2 10 11 12 14 Next →
  • Don't see your idea?