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.

How can we improve SQL Prompt?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Expand Wildcards with alias and equal sign

    When I expand Wildcards I would like it like

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

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add $Query$ to execute when inserting a snippet

    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…

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Expand wildcards  ·  Flag idea as inappropriate…  ·  Admin →
  3. INSERT INTO Wildcard

    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.

    7 votes
    Sign in
    (thinking…)
    Password icon
    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?

Feedback and Knowledge Base