Text copied!
INSERT INTO SELECT statement
You can use "INSERT INTO" with "SELECT" statement to copy or transfer data between SQL tables.
It is commonly referred to as the "INSERT INTO SELECT" statement.
Here's the syntax for "INSERT INTO SELECT" statement :
INSERT INTO destination_table_name
(column1, column2, column3, ...)
SELECT
column1, column2, column3, ...
FROM source_table_name;
The rules for using the "INSERT INTO SELECT" statement are :
1. The destination table must exist.
2. The columns in the source and destination tables must match in terms of data type and order.
3. The "SELECT" statement must return the same number of columns as the destination table.
4. INSERT permissions are required on the destination table.
5. You can specify specific columns in the "INSERT INTO" clause.
6. SELECT Statement can select data from one or more tables by using UNION or JOIN.
Here's an example of how to copy or transfer data between SQL tables :
1. Suppose we have two tables, named [Product1] and [Product2] where [Product1] contains some records and [Product2] is currently empty.
2. Let's copy or transfer the data from product1 to product2. Run the below code :
INSERT INTO [Product2]
( [DepartmentID], [Name], [GroupName], [ModifiedDate] )
SELECT
[DepartmentID], [Name], [GroupName], [ModifiedDate]
FROM
[Product1];
3. Above statement will copy or transfer the data from [Product1] table to [Product2] table for the all specified columns.
That's it! You have successfully copy or transfer data between SQL tables.