sql try/catch回滚/提交——在回滚之后防止错误提交

I am trying to write an MS sql script that has a transaction and a try/catch block. If it catches an exception, the transaction is rolled back. If not, the transaction is committed. I have seen a few different websites saying to do it like this:I am trying to write an MS sql script that has