insert into [tableName] (FID,UseWorker,CodeNum,Status,ReCardID,FIsDel)
select 1,'aa','aa',0,1,0 union all
select 2,'aa','aa',0,1,0 union all
select 3,'aa','aa',0,1,0
语法:
insert into 表名 (字段名)
select 具体值 union all
...........................................
select 具体值
批量添加,通常考虑到程序效率问题,我建议除了拼写上面这条sql语句,最好还写存储过程!