Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

  • April 3, 2014 at 11:36 am

    #1702981

    Thanks, Gregory !!

    I heard that these days ( after 2008R2) we don't need to CREATE #Temp , you can just do SELECT * INTO #TEMP FROM dbo.Table, it won't be any difference in performance, locking, multitasking etc...

    Not sure if I want to put any indexes on #temp how this will work, can I do SELECT INTO #TEMP and then Create IDX?

    Appreciate your feedback..

    Tx

    mario