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

What programming language would you use to create embedded functions in ssrs?

184

How to list all field names in the result set using mssql_field_name()?

914

What is merge replication?

1105

Tell me what are the advantages of using stored procedures?

1014

What is acid properties?

1099

can SSRS reports Cache results?

147

What is advantage data architect?

924

Why we use functions in sql server?

1077

What does sql server mean?

1068

How many types of triggers in sql server?

1031

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1965

What are magic tables in sql server?

1133

Explain the concept of view and Types of views in SQL server?

993

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4385

What is instead of trigger sql server?

1001