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

Explain transaction isolation levels in sql server?

1035

What are the basic features of a trigger in ms sql server?

1109

What is a subquery in a select query statement in ms sql server?

1065

What are the different kinds of ssrs reports?

206

Explain what stored procedure sp_replcounters is used for? : sql server replication

1452

What does top operator do?

963

Explain the steps to use transact-sql cursor?

957

What is sql injection? How to protect against sql injection attack?

941

How to list all columns in a table using odbc_columns()?

935

Why we should not use triggers?

919

How do you know if sql server is running on your local system?

975

What is difference between commit and rollback when used in transactions?

904

What is policy management?

933

Explain triggers?

942

Define the one-to-one relationship while designing tables.

855