INSERT


insert into table (...columns) values (...values);

insert into table1 (...columns) select (...columns);
	from table2
	where column=value

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/

SQL Server INSERT Multiple Rows Into a Table Using One Statement

Recommendations

////////