HW TO COPY THE DATA OF ONE TABLE TO ANOTHER TABLE IN SQL SER

Question

QUERY WITH DETAILS EXAMPLE

Palle Technologies · Answer

create table t1 ( c1 int c2 varchar(20)) insert into t1 values (1'lok') insert into t1 values (2'rajeev') --now copy the above tables data into another table. case1: when destination table is not existing use below query select * into newtablename from t1 case2: assume you have another table with same structure as t1 table and assume its name as t2. then use below query insert into t2 select * from t1 hope this helps.

JAYRAM · Answer

insert into table2 select * from table1

Jignesh Trivedi · Answer

hi Please refer http://www.c-sharpcorner.com/UploadFile/1e050f/copy-table-schema-and-data-from-one-database-to-another-data/ http://www.c-sharpcorner.com/Blogs/11499/insert-data-from-one-table-to-another-table-in-sql-server.aspx http://www.c-sharpcorner.com/UploadFile/rohatash/copy-table-with-data-from-one-database-to-another-in-sql-ser/

Vithal Wadje · Answer

yes correct Palle tech