SQL Server INSERT Multiple Rows Into a Table Using One Statement
Summary: in this tutorial, you will learn how to insert multiple rows into a table using a single SQL Server INSERT statement. In the previous tutorial, you have learned how to add one row at a time to a table by using the statement.
https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-multiple-rows/