add multiple rows sql 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: SQL Insert Multiple Rows
INSERT INTO StudentTable
( Rollo, Name, Class, Contact )
VALUES ( '1', 'Jonny', '10th', '9856245' ),
( '2', 'Ronny', '12th', '5421545' );
Example 3: insert multiple rows in sql.
INSERT INTO table (col1, col2, col3)
VALUES
(row1_val1, row1_val2, row1_val3),
(row2_val1, row2_val2, row2_val3),
(row3_val1, row3_val2, row3_val3);