没碰到过,这样试试
begin transaction yourtran
execute('insert into OutPool values(...)')
update BookBase set Valid = 4
if (@@error = 0)
commit transaction yourtran
else
rollback transaction yourtran
begin transaction yourtran
execute('insert into OutPool values(...)')
update BookBase set Valid = 4
if (@@error = 0)
commit transaction yourtran
else
rollback transaction yourtran
这样也试过,但这段程序是写在一个循环里的,这样一写,循环体就执行一次就退出来了。
有时间可以帮我看一下:http://www.csdn.net/Expert/TopicView1.asp?id=794298
谢谢