请问这段代码里的commit 不是已经提交了么？ CATCH 里的 ROLLBACK 还有用么？

Question

begin trybegin transaction trselect * from Car_Brandupdate car_log set [reason]='ceshiceshiceshi' where [modelid]=557;select 1/0print 'i have executed!'select * from AREAprint 'executed success';commit transaction tr <-----------------------------------------------end trybegin catchprint 'executed failed';rollback transaction trend catch

Answer 1

begin catch ... end catch 里的内容，只有在 begin try ... end try 里的内容执行有错误才会触发到，所以， commit tran 执行成功的话，是不会执行到 rollback tran 的