sqlserver事务和回滚
Declare @tranName varchar(32)
Select @tranName='MyTran'
Begin tran @tranName
delete from Products where ProductID=1
save tran save_point
delete from [Order Details] where ProductID=1
if @@error=0 then
begin
rollback tran save_point
commit tran MTran
end
else
commit tran MTran
Go
如果中途没有出错,这个执行顺序是什么?出错了其执行顺序又是什么?