What is the effect of a TRANSACTION on local variable values after ROLLBACK and after COMMIT? A short example I wrote for a Jr. Developer shows the answer.
A Quote of the Day From a Table, With No Repeats Until All Are Used
Build a quote of the day table that rotates without repeats, handles concurrent requests, and supports a stable date-based selection.
Replacing @@ERROR Checks With TRY CATCH in Old Procedures
Replace fragile @@ERROR checks with TRY CATCH, transaction state checks, and THROW while preserving clear failure information for callers.
Last Line of a SQL Script: The Joke Every DBA Has Lived
The last line of a SQL script decides whether your work is saved, rolled back, or still holding locks. Here are the classic endings and how to check them.
SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
An SSIS package fails with Error 3902: the COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Two fixes, one is RetainSameConnection set to true.