SELECT INTO

SELECT INTO

--==============================================[SELECT INTO]===============================================================

--The SQL SELECT INTO statement is used to select data from a SQL database

--table and to insert it to a different table at the same time.

--Select Into table(copy entire data)---

SELECT *

INTO table2

FROM table1

--Select Into (copies selected columns)--

SELECT Column1, Column2, Column3,

INTO Table2

FROM Table1