declare @tranname varchar(32)
select @tranname='mytran'
begin tran @tranname
delete from student where xu_lie=3
save tran save_point
delete from stuok where score=6000
if @@error=0
begin
rollback tran save_point
commit tran mytran
end
else
commit tran mytran
是判断上一条是否出错, = 0 表示没出错, 也就是 delete from stuok where score=6000 成功按照写的语句, 意思是 ( 似乎逻辑和正常的有点不一样)
如果 delete from stuok where score=6000 成功
则回滚 delete from stuok where score=6000 的操作
只做 delete from student where xu_lie=3 如果 delete from stuok where score=6000 失败
则提交所有的事务, 即要求完成所有的操作
@@error=1
@@error=2
@@error=3
请问一下这些都是什么意思???谢谢.
楼上的地址真的很详细