Copy data into another table

How to copy/append data from one table into another table with same schema in SQL Server?

Edit:

let’s say there is a query

select * 
into table1 
from table2 
where 1=1 

which creates table1 with the same schema as well as data as in table2.

Is there any short query like this to only copy entire data only into an already existing table?

11 Answers
11

Leave a Comment