SQL Server - want to insert one column data from one table into another table's column

Asked By ali shaik on 12-Jul-12 02:23 AM
Asked By ali shaik on 12-Jul-12 02:30 AM
  i want to insert one column data from  table1 into table2 column but before doing this operation the data
 
 which is already present in that table2 's column will be deleted then after the above insertion have to be done


 send me the code,,,,,,,,,
Jitendra Faye replied to ali shaik on 12-Jul-12 02:32 AM
Simply use this command-

INSERT INTO TABLE2 (COL1, COL2) SELECT COL1, COL2 FROM TABLE1
ali shaik replied to Jitendra Faye on 12-Jul-12 02:33 AM



      i want to insert one column data from  table1 into table2 column but before doing this operation the data
 
 which is already present in that table2 's column will be deleted then after the above insertion have to be done

,,,,,,,,,