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
    0 comments  ·  Expand wildcards  ·  Admin →
    How important is this to you?
  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
    0 comments  ·  Expand wildcards  ·  Admin →
    How important is this to you?
  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
    How important is this to you?
  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
    How important is this to you?
  5. When I expand Wildcards I would like it like

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

    4 votes
    How important is this to you?
  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
    How important is this to you?
  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
    How important is this to you?
  • Don't see your idea?