T-SQL INSERT INTO SELECT and SELECT INTO

A common task when using Transact-SQL (T-SQL) is to copy information from one table into another, possibly changing the data or its structure in the same operation. This can be achieved by combining the standard SELECT and INSERT commands. Copying Data Between Tables   It is common to want to copy information from one table into another using T-SQL, possibly within a stored procedure. This is