Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result 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
    Alex den Haan commented  · 

    You can also select into a temp table.
    SELECT
    fld1
    ,fld2
    INTO #tmpTbl
    FROM Tbl