Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

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

Edit:

I mean to say there is 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?

1 Answer

0 votes
by (40.4k points)

If both tables are truly the same schema:

INSERT INTO newTable

SELECT * FROM oldTable

Otherwise, you need to specify the column names:

(If you are specifying the value for all columns and selecting columns in the same order as newTable's schema, then the column list for newTable will be optional ):

INSERT INTO newTable (col1, col2, col3)

SELECT column1, column2, column3

FROM oldTable

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...