How to use SQL INSERT INTO SELECT Statement
By FoxLearn 2/19/2024 9:49:46 AM 91
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
- How to export data to .csv file
- How to Read Excel file and Import data from Excel to SQL Server in C#
- How to Create a backup SQL Server in C#
- How to Search data from Database in C#
- How to rename a column name in SQL
- How to add primary key to existing table in SQL Server
- How to add index in SQL Server
- How to Download and Restore Northwind database to SQL Server