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

How do I find the size of a sql server database?

488

Does partitioning ssd reduce performance?

486

What is tablix?

115

What number sorts of privileges are accessible in sql?

593

Determine when to use stored procedure to complete sql server tasks?

532

How to drop an existing user defined function in ms sql server?

559

Why Master database is required?

596

Can primary key be null?

509

What is Service Broker in sql server 2012?

616

What is cursors? And what are the different types of cursor?

553

How many types of functions are there in sql server?

457

What are statistics?

566

Can we use trigger new in before insert?

512

query processing

1736

What is the server name for sql management studio?

473