//Oracle批量插入 dual为系统参数 insert into Test(name,Value) select '1','1' from dual union all select '2','2' from dual union all select '3','3' from dual union all select '3','3'from dual
SQL server批量插入
insert into ys (Name,Value) values ('1','1'), ('2','2'), ('2','2'), ('3','3'), ('4','4')