How to use SQL INSERT INTO SELECT Statement
By FoxLearn 2/19/2024 9:49:46 AM 61
It allows you to select data from one or more tables and insert it into another table in a single SQL statement. It's requires that the data types in source and target tables match
Here's the basic syntax of the INSERT INTO SELECT statement
INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM source_table WHERE condition;
- target_table
: The name of the table where you want to insert data.
- (column1, column2, ...)
: The columns in the target table where you want to insert data.
- source_table
: The name of the table from which you want to select data.
- column1, column2, ...
: The columns in the source table that you want to select data from.
- WHERE condition
: An optional condition that filters the rows to be copied from the source table.
sql server insert into select example
Suppose we have two tables: Customers and Persons.
We want to copy the data of persons from the Persons table into the Customers table.
INSERT INTO Customers (CustomerName, City, Country) SELECT Name, City, Country FROM Persons;
Run this query will help you copy all data from the persons table into the customers table
- SQL Server Migration Assistant
- How to Download and Restore Northwind database to SQL Server
- Data type SQL Server
- How to drop table if exists in sql server
- How to fix 'The specified directory for the INSTALLSHAREDDIR parameter is not valid'
- How to get all table names of a particular database using TSQL
- How to use ROW_NUMBER Function in SQL Server
- How to convert varchar to uniqueidentifier in SQL Server