Insert statement for inserting multiple rows of data into a table in sqlserver

The following describes the solutions of a master in SQL.
For your reference:

Assume that a table contains three columns: Student ID, name, and school.
Then insert data into the table.
040501 Sun Ming Shandong University
040502 Li Hao Shandong Normal University
040503 Wang Gang Yantai University
How to insert these three rows of data ~~~~~~~

Copy codeThe Code is as follows:
Insert table name
Select '200', 'Sun ming', 'shandong 'union
Select '123', 'Li hao', 'shandong normal Teachers' union
Select '123', 'wang gang', 'yantai Emy'