110,534
社区成员
发帖
与我相关
我的任务
分享
while 1=1
begin
insert into table ...
if @@rowcount>10 break;
end
String Sql = "INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);
INSERT INTO tableA(a,b,c,d) VALUES ('','',0,0);";
sqlCommand.CommandText = Sql;
sqlCommand.ExecuteNonQuery();