4,012
社区成员
发帖
与我相关
我的任务
分享
for(int io=0;io<20000;io++)//38875ms
{
sql.Format("INSERT INTO %s VALUES('%s','%lf')",var[io],time[0],value[0]);
}
USE YourDB
SET NOCOUNT ON ;
BEGIN TRY
BEGIN TRANSACTION;
INSERT ...
INSERT ...
INSERT ...
INSERT ...
--把你的语句写进来
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION ;
END
END CATCH;
insert into tb(stu_no,stu_name)
select '001','zhangsan'
union all select '002','lisi'
union all select '003','wangwu'
union all ..........