insert multiple values sql server code example

Example 1: sql server insert multiple rows

INSERT INTO table_name (column_list)
VALUES
    (value_list_1),
    (value_list_2),
    ...
    (value_list_n);

Example 2: insert multiple values into one column sql

INSERT INTO Data ( Col1 ) VALUES
('Hello'),
('World');