Sql server insert multiple rows

This article is tagged with: Sql server insert multiple rows and mysql

sql server insert multiple rows

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

SQL Insert Multiple Rows

INSERT INTO StudentTable
( Rollo, Name, Class, Contact )
VALUES ( '1', 'Jonny', '10th', '9856245' ),
( '2', 'Ronny', '12th', '5421545' );

This article is tagged with: Sql server insert multiple rows and mysql