Exception Handling in Yukon Transactions
Ok, it is Friday, so an easy one to digest, but quite powerful. Yukon has made a major improvement in Error Handling inside of TSQL transactions. You can now catch Transaction Abort Errors using the TRY / CATCH model without any loss of the transaction context. This makes me very happy. The syntax is here:
BEGIN CATCH TRAN_ABORT
See my article on SQLJunkies.com.
Page rendered at Sunday, August 7, 2022 12:10:19 PM (Eastern Daylight Time, UTC-04:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in anyway.