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

    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

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    1 comment  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    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

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?