sqlserver 批量插入

我写点伪代码： private InsertData(){ var StartId = exec("select max(id) from table1"); for(var i =1;i10;i++){ exec("insert Table1(Name) values('Name"+i.ToString()+"')") } var EndId = exec("select max(id) from table1"); for(var i =StartId;i

我写点伪代码：

private InsertData(){
  var StartId = exec("select max(id) from table1");

  for(var i =1;i

    exec("insert Table1(Name) values('Name"+i.ToString()+"')")

  }
  var EndId = exec("select max(id) from table1");

  for(var i =StartId;i

    exec("insert Table2(MainId) values('"+i.ToString()+"')")

  }

}