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 to provide values to stored procedure parameters in ms sql server?

987

What is de-normalization and what are some of the examples of it?

942

What are the steps to process a single select statement?

905

What is a collation in ms sql server?

1029

What is a system database and what is a user database?

1042

What is subquery explain with example?

1024

How to drop an existing stored procedure in ms sql server?

988

What is sub-query in sql server?

1163

What is unpivot?

978

What is the difference between substr and charindex in the sql server?

1024

What method is used by the Command classes to execute SQL statements that return single values?

1022

What is difference between temp table and cte?

972

How do I find the sql server database version?

960

what are the Prerequisites for Replication?

11266

Why are you getting errors when creating a new odbc dsn?

1184