Insert statement

• DuruG

  SSCrazy

  Points: 2089

  More actions

  March 19, 2002 at 9:28 am

  #78062

  Hi!

  Lets say it I have 2 tables. First one has Name and eMail and second one has ID (Identity), Name and email. What is the corect syntax for inserting the name and email from the first table into the second one without using a cursor.

  Thank you,

  Radu

• jamestow

  SSC Veteran

  Points: 204

  More actions

  March 19, 2002 at 9:36 am

  #425642

  Something like this would work. I included the table DDL for clarity:

  CREATE TABLE TABLE1 (FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

  CREATE TABLE TABLE2 (IDEN NUMERIC(12) IDENTITY(1,1), FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

  INSERT INTO TABLE2 (FULLNAME, EMAIL)

  SELECT FULLNAME, EMAIL FROM TABLE1