Insert statement that inserts multiple rows of data into a table in SQL Server _mssql

The following is a master in the SQL Bar solution, announced.
For your reference:

Let's say there's a list of school numbers, names, schools, three columns.
And then insert it 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 Ah ~~~~~~~

Copy Code code as follows:

Insert Table name
Select ' 040504 ', ' Sun Ming ', ' Shandong University ' union
Select ' 040502 ', ' Li Hao ', ' Shandong Normal ' union
Select ' 040503 ', ' Wang Gang ', ' Yantai University '