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

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.

insert into table2
select * from table1

yes correct Palle tech