Categories
SQL

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