• the question should include SQL versions. the following does not work prior to 2008.

    INSERT INTO @student

    VALUES( 'Hardy', 100), ('Rocky', 98), ('Panky', 99)