T-SQL INSERT INTO SELECT and SELECT INTO - BlackWasp Software Development Home

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.

www.blackwasp.co.uk