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
SQL Server Transact Basic to Expert - Select Query with INTO Clause
SQL Server Transact Basic to Expert - Select Query with INTO Clause
Join the conversation! Your thoughts help the community grow.