Transactions: BEGIN TRAN, COMMIT, ROLLBACK and @@TRANCOUNT
Lessons in this course
- T-SQL Query Anatomy: Schemas, TOP and Logical OrderFree
- INNER vs LEFT JOIN and the ON-versus-WHERE Trap Locked
- LEFT JOIN + GROUP BY: COUNT, ISNULL and Honest Averages Locked
- Three-Table Joins and the Row-Multiplication Trap Locked
- Variables: DECLARE, SET and SELECT Assignment Locked
- Dates in T-SQL: DATEADD, DATEDIFF and EOMONTH Locked
- CASE and IIF: Turning Rules into Columns Locked
- Subqueries: Scalar, EXISTS and the NOT IN NULL Trap Locked
- CTE Basics: Name a Step, Use It Twice Locked
- ROW_NUMBER in a CTE: Latest per Group and Running Totals Locked
- Recursive CTEs: Exploding a Bill of Materials Locked
- Recursive CTEs as Generators: A Calendar of Days Locked
- IF...ELSE and BEGIN...END: Control Flow Locked
- WHILE Loops, BREAK, CONTINUE and @@ROWCOUNT Locked
- Stored Procedures: Parameters, Defaults and EXEC Locked
- OUTPUT Parameters and RETURN Codes Locked
- Temp Tables and Table Variables: A Staging Script Locked
- Transactions: BEGIN TRAN, COMMIT, ROLLBACK and @@TRANCOUNT Locked
- TRY...CATCH, XACT_STATE and Atomic Statements Locked
- The OUTPUT Clause: inserted, deleted and Audit Trails Locked
- MERGE: Insert, Update and Delete in One Statement Locked
- Final Project: A Robust Nightly Stock Sync Procedure Locked