Skip to content
← Customer Feedback for Redgate

Settings and activity

4 results found

  1. Highlight a SELECT stmt and create a temp table definition from it.

    31 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  SQL Prompt » Script object as alter  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Anonymous commented  · 

    SQL Prompt has a way to do this. You can select into a temp table

    SELECT A, B, C INTO #TempTable FROM Table

    Sometimes you have to run the query once first but you can hover over the #TempTable name and it will provide the CREATE Table script for that temp table. Just copy, paste at the top, generate the INSERT and remove the INTO #TempTable from the query.

    Hope this helps, I use it a LOT.

  2. Create CRUD

    34 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  SQL Prompt  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Anonymous supported this idea  · 

  3. Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words. "Status", "Type",etc.",

    31 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  SQL Prompt » Format SQL  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    Anonymous supported this idea  · 

  4. Tab History Cloud Sync

    39 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    4 comments  ·  SQL Prompt » Tab history  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    Anonymous commented  · 

    I just lost my hard drive on my laptop. It is encrypted so I can't get the history database off of it. More and more organizations are going to encrypted hard drives that prevent getting the data off without significant effort.

    Syncing to the Cloud (i.e. Google Drive, Network Share, OneDrive, Google Drive Stream, AWS, etc.) would be extremely helpful.

    Anonymous supported this idea  ·