SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Oct 09
SQL Comments Off
INSERT INTO MyTable (FirstCol, SecondCol) SELECT 'First', 1 UNION ALL SELECT 'Second', 2 UNION ALL SELECT 'Third', 3
Oct 09
SQL Comments Off
INSERT INTO MyTable (FirstCol, SecondCol) SELECT 'First', 1 UNION ALL SELECT 'Second', 2 UNION ALL SELECT 'Third', 3