SQL Server INSERT Multiple Rows Declarations: 2) Inserting multiple rows and returning the inserted id list example But what we really want is inserting a generic collection, so called Batch Insert: < BACK | HOME