INSERT INTO MyTable (FirstCol, SecondCol) SELECT 'First', 1 UNION ALL SELECT 'Second', 2 UNION ALL SELECT 'Third', 3
My Online Notepad
INSERT INTO MyTable (FirstCol, SecondCol) SELECT 'First', 1 UNION ALL SELECT 'Second', 2 UNION ALL SELECT 'Third', 3