SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL

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