Home Forums SQL Server 2005 Administering Which one is better select * into # temp from tableA Vs create #temp table insert into... RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

  • June 22, 2011 at 5:12 am

    #1342310

    Another thing to consider is collation.

    SELECT INTO will always get the collation of character columns correct.

    If you do use the CREATE TABLE method then the collation should always be specified, normally by COLLATE DATABASE_DEFAULT, just in case the DB has a different collation to tempdb.