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 is a correlated sub-query? : Sql server database administration

681

How to create median function?

135

Explain indexes disadvantages?

755

What does normalization do to data?

726

what is denormalization? : Sql server database administration

658

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

699

Why do we use sql limitations? Which constraints can we use while making a database in sql?

746

How to provide default values to stored procedure parameters?

755

What are the character string functions supported by sql server 2005?

702

Can we use max in where clause?

697

What are pages and extents? : SQL Server Architecture

721

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

810

How to delete an existing row with delete statements in ms sql server?

774

Do you know the isolation level that sql server support?

712

What is mean by candidate key?

752