Skip to content
Deadline to Die

07. T-SQL Programming

Overview

T-SQL is more than just queries; it’s a procedural language for database-side logic.

Topics Covered

  • T-SQL Variables & Flow Control: DECLARE, SET, IF...ELSE, and WHILE.
  • Stored Procedures: Encapsulating logic for reuse and security.
  • User-Defined Functions (UDFs): Scalar vs. Table-Valued functions.
  • Triggers: Automating actions on DML events (AFTER and INSTEAD OF).