Explain SELECT INTO statement in SQL Server.

The SELECT INTO statement is used to select data from a database table and to insert it to a different table at the same time.

Ex :

Select * into Departments from Employees

This Query will select data from “Employees” table and insert into “Departments.