Categories SQLSQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL Post author By Melvin Post date October 9, 2007 INSERT INTO MyTable (FirstCol, SecondCol) SELECT ‘First’, 1 UNION ALL SELECT ‘Second’, 2 UNION ALL SELECT ‘Third’, 3