SELECT INTO SQL Server: Create Table from Query
In SQL Server, the SELECT INTO statement is used to insert query results into a new table. Its purpose is to store query results in a new table, making it easy to copy data from one table to another or create a new table and store query results in it. The SELECT INTO statement can efficiently copy data and create a new table in one go, making it very convenient.