insert multiple data from one table to another

• igngua

  SSCrazy

  Points: 2510

  More actions

  December 29, 2009 at 1:03 pm

  #213939

  Hello.

  Hi have table 1 and table 2. I need to insert all the data from a select statement from table 1 to table 2.

  thanks in advance.

• itskumar2004

  Default port

  Points: 1446

  More actions

  December 29, 2009 at 1:19 pm

  #1097202

  Here you go ,

  Insert table2

  (col1,col2......coln)

  select (col1,col2...coln)

  from table1

  with this script you can insert all rows from table1 to table2

• igngua

  SSCrazy

  Points: 2510

  More actions

  December 30, 2009 at 11:58 am

  #1097599

  thanks!!!