if (not adoconnection1.intransaction) begin adoconnection1.begintrans; end ; try //你的代码 adoconnection1.committrans; except //你的错误提示 adoconnection1.rollbacktrans; end;
谢谢楼上三位: to SnowTopCh:我用的是SQL Server2000,怎么在存储过程里面添加事务呢?能否举个例子?
begin transaction go delete employee go select 'bofore rollback '; select * from employee; go rollback transaction go select 'after rollback ' select * from employee go
begin
adoconnection1.begintrans;
end ;
try
//你的代码
adoconnection1.committrans;
except
//你的错误提示
adoconnection1.rollbacktrans;
end;
except
//你的错误提示
adoconnection1.rollbacktrans;
end;
改成
except
adoconnection1.rollbacktrans;
//你的错误提示
end;
to SnowTopCh:我用的是SQL Server2000,怎么在存储过程里面添加事务呢?能否举个例子?
go delete employee
go
select 'bofore rollback ';
select * from employee;
go
rollback transaction
go
select 'after rollback '
select * from employee
go
我去试一试。