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

Why the trigger fires multiple times in single login?

1275

how to create a scrollable cursor with the scroll option? : Sql server database administration

1142

Define constraints and give an example of their use?

1092

What is Sqlpaging in SqlServer 2005 ?

1111

What do you understand by mirroring and mention the advantages of the mirroring?

1112

What is table value parameters (tvp)?

1142

How to concatenate two character strings together?

1164

What is it unwise to create wide clustered index keys?

1042

Explain cdc and sql injection?

1040

Explain trigger and trigger types?

1031

Can you please explain the difference between primary keys and foreign keys?

1165

How many instances per computer are there in sql server 2000?

1117

What are system databases in ms sql server?

1117

What is filter index?

989

How to handle error or exception in sql?

1030