HW TO COPY THE DATA OF ONE TABLE TO ANOTHER TABLE IN SQL SER
QUERY WITH DETAILS EXAMPLE
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
JAYRAMPosted Apr 5, 2014, 7:40 AM
select * from table1
Jignesh TrivediPosted Apr 2, 2014, 3:57 AM
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 WadjePosted Jan 25, 2014, 1:20 PM
Palle TechnologiesPosted Jan 25, 2014, 10:00 AM
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.