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

7 results found

  1. I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
    e.g.
    If I have something with a pivot
    Sum(Amount) for month_no in ([1],[2],[3]....)
    When the pivot result is expanded, it becomes [12],[11],[10]....
    Would be nice if the expansion would match the order that the columns was entered in.

    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  ·  Expand wildcards  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Currently it is hardly possible to search for column assignments like "Column1 = 0". The results include any words having zero.

    This request is similar to the "allow multiple keywords searches", but it is for a button named "SQL Search" instead of "Tab History".

    Either treat "match whole words only" as the entire search text entered is matched exactly or introduce another checkbox "Search as Regex" to handle this scenario.

    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  ·  Expand wildcards  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. When SQL Prompt gives you the option to expand wildcards by typing a TAB, can you make it possible to add a modifier key (say Alt-TAB or Ctrl-TAB) that will generate aliased column names based on the table name?
    For example, on an insert or update statement, we can use the OUTPUT clause to capture the changes made to a table. So, currently, typing Deleted.* and pressing TAB will generate columns such as
    Deleted.Id,
    Deleted.ModifiedDate,
    Deleted.Description
    and so on.

    It would be more useful to have
    Deleted.Id as DeletedId,
    Deleted.ModifiedDate as DeletedModifiedDate,
    Deleted.Description as DeletedDescription

    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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. Can we have a keyboard shortcut for "Script Object as ALTER"? You had it before but it isn't available with the latest version.

    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)
  5. When I expand Wildcards I would like it like

    Select col1 = tb.col1
    col2 = tb.col2
    FROM tb

    4 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. Add $query$ to SQL prompt that allows you to define a query which get executed and the results pasted in place, optionally formatted as VALUES statement

    I currently have a snippet that runs
    SELECT '(' + CAST(r.RegionId AS VARCHAR(50)) + ',''' + r.RegionDescription + ''',0),'
    FROM retail.Regions r
    WHERE r.ActiveTo > GETDATE()
    ORDER BY r.RegionDescription

    I then copy the output and use the $paste$ place holder in another snippet to paste in

    DECLARE @regions TABLE (RegionId INT, RegionDescription VARCHAR(50), Active bit)
    INSERT @regions (RegionId, RegionDescription, Active)
    VALUES
    --$PASTE$ goes here
    (117,'Anglia',0),
    (119,'Greater Manchester',0),
    (145,'Hampshire',0),

    An improvement would be remove the…

    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)
  7. When doing an INSERT INTO it would be nice if you could type INSERT INTO TableName (*) then if you tabbed after the * it would expand out all the columns for that table.

    9 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?