Home Forums SQL Server 2008 SQL Server 2008 - General how to add data to two table RE: how to add data to two table

  • October 16, 2012 at 5:26 am

    #1549472

    select into will make new table with the same column name and datatype, if you add false condition then only data schema will be copied without ady data

    select * into NEWTABLE from OLDTABLE where 1=0