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

Related posts:

  1. Insert data from one table to another table INSERT INTO "table1" ("column1", "column2", ...) SELECT "column3", "column4", ......
  2. SELECT RIGHT RIGHT Returns the part of a character string starting a...
  3. IsNumeric function The function returns 1 for numeric values, and 0 for...