Insert (SQL) - Wikipedia, the free encyclopedia

Note that the two separate statements may have different semantics (especially with respect to statement triggers) and may not provide the same performance as a single multi-row insert. To insert multiple rows in MS SQL you can use such a construction:

en.wikipedia.org