SQL Server Transact Basic to Expert - Select Query with INTO Clause

This blog shows how to make use of the INTO clause with the select clause. INTO clause used to make the select result to another table

Syntax:

Select column1, column2
Into table2
From table1

Example:

Select Empname, Empsal
Into Temptable
From emptable