You can also create the same table for experiment with the following code:.

Showing the data of dbo.Companies table INSERT INTO dbo.Companies(Company_Name, Country)

Now I will use the INSERT INTO SELECT statement to copy data from the dbo.RankCompany table into the dbo.Companies table as:.

Let us create another table where we want to copy this data.

In this case you can use the INSERT INTO SELECT statement to copy only the required column into another table.

Now suppose you want to put this data into another table, but without the rank.

I have provided the code for the table so that you can try it at your end.

For example, I have created a table where I have stored the basic information of the top 10 companies in the world by market cap, say dbo.RankCompany.

VALUES(SELECT column1, column2, column3 from )

Let us see a general syntax for using this statement. In case you have to copy data from one SQL server table into another in SQL Server, you can use the INSERT INTO SELECT statement. SQL Server INSERT INTO SELECT from another server.SQL Server INSERT INTO SELECT from another database.Insert into select SQL Server temp tableįor all the examples, we have used SQL server 2019 express and SQL server management studio.SQL Server insert into select from same table.SQL Server insert into select not exists.SQL Server insert into select avoid duplicates.SQL Server insert into select from another server.SQL Server insert into select from another database.SQL Server insert into select from multiple tables.SQL Server insert into select multiple rows.SQL Server insert into select without column names.SQL Server insert into select with auto-increment.SQL Server insert into select with identity_insert on.SQL Server insert into select without identity column.SQL Server insert into select with identity column.SQL Server insert into select with where clause.SQL Server insert into select statement.

Also, we will see some use cases of this statement. We will see a number of examples using this statement. We use this statement when we want to insert a row into a table with the data from another table. In this article, you will learn about the SQL Server INSERT INTO SELECT statement.

Select into sql server