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

6 results found

  1. CREATE TABLE dbo.GrumpyOld (col1 int)

    SQL Prompt will alias the table as GO, which causes problems because it's a batch separator.

    Thanks!

    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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  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 7.3 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

  2. Hi, It would be great, if you add precision and scale on numeric/decimal data types - column hint and table summary.

    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

    2 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  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 7.3 of SQL Prompt.

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

    Kind Regards,
    The Prompt Team

  3. Correctly qualify the Table Value Constructor.

    I frequently use a TVC to find the Max value among several values on a single row, as with the following:

    ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
    SELECT
    MyCte.a,
    MyCte.b,
    MyCte.c,
    HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Val))
    FROM MyCte

    When I qualify object names within that script, it incorrectly tries to add the 'Value' as a qualifier within the constructor:

    ;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
    SELECT 
        MyCte.a,
        MyCte.b,
        MyCte.c,
        HighestNumber = (SELECT MAX(Value.Val) FROM
    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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  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

    Thanks for letting us know about this issue. It should now be fixed in the latest build of SQL Prompt (7.1.0.314)

  4. Using PIVOT the wrong alias is suggested in the intellisense window as it is the alias from the FROM clause, not the PIVOT clause that is displayed.

    The same goes for the auto complete, where field names is (automatically) prefixed with the wrong alias (I know this feature can be disabled...)

    Ex:[code]CREATE TABLE dbo.tbTest(
    Id INT,
    foo VARCHAR(3),
    bar FLOAT
    )
    GO
    INSERT INTO dbo.tbTest
    VALUES (1, 'foo', 2)
    , (2, 'bar', 3)
    , (3, 'foo', 4)
    GO
    SELECT *
    FROM (
    SELECT *
    FROM dbo.tbTest AS tt
    ) pvt
    PIVOT (
    MAX(bar) FOR foo IN ([foo], [bar])
    )p
    [/code]…

    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

    2 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  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. The qualify column names should work with temporary tables as well.

    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

    1 comment  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

    0 comments  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →
    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?