INSERT INTO TABLE_2 SELECT * FROM TABLE_1 OR INSERT INTO TABLE

How to a Query to copy data from on table to another table.

Question Posted / gali kondareddy

Answer Posted / gali kondareddy

INSERT INTO TABLE_2 SELECT * FROM TABLE_1

OR

INSERT INTO TABLE_2 SELECT * FROM TABLE_1 WHERE 1=1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When would you use it?

987

How to get the query of a table in sql server?

893

what is a check constraint?

1097

What is a trigger what are the advantages of trigger?

995

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

tell me the disaster recovery plan

2512

How many triggers you can have on a table?

993

What is a full text index?

917

Can you explain important index characteristics?

987

How can we migrate from SQL server to SQL Azure?

113

Mention a few common trace flags used with sql server?

926

Can we perform backup restore operation on tempdb? : sql server database administration

990

What is Cross Join and in which scenario do we use Cross Join?

1011

what are the disadvantages of cursors? : Sql server database administration

1028

Can we perform backup restore operation on tempdb?

1004