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 Friday, September 20, 2019 10:54:43 AM (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.