
SQL Transact INSERT … SELECT Statement This example not only inserts data, but it inserts records with style. INSERT… SELECT works well when you already have the data elsewhere, in another table for example. Lesson 1 – INSERT … SELECT The scenario: You want to add your employees to the …