可以把事务加到sql里来做,如下...... sqlinsert=" set xact_abort on begin tran insert into requisitionka (num, pfplace, name, prnum, pic, usename) select num, pfplace, name, prnum, pic, usename from opendatasource('sqloledb', 'data source=(local); user id=stampka; password=stampka').stampka1.dbo.requisition where num not in (select num from requisitionka) and replyname4 is not nullif @@error<>0 rollback trancommit tran " connchkka.execute(sqlinsert)看看是否可以阿。。
sqlinsert="
set xact_abort on
begin tran
insert into requisitionka (num, pfplace, name, prnum, pic, usename) select num, pfplace, name, prnum, pic, usename from opendatasource('sqloledb', 'data source=(local); user id=stampka; password=stampka').stampka1.dbo.requisition where num not in (select num from requisitionka) and replyname4 is not nullif @@error<>0
rollback trancommit tran
"
connchkka.execute(sqlinsert)看看是否可以阿。。
-----------^