T-SQL by Example

Programmability

  1. 🚧 Variables & Expressions — DECLARE, SET vs SELECT assignment, expressions.
  2. 🚧 Stored Procedures — Input/output params, RETURN, OUTPUT.
  3. 🚧 Functions: Scalar vs TVF — Scalar UDF, inline TVF, multi-statement TVF (perf notes).
  4. 🚧 TVPs (Table-Valued Parameters) — Table types and passing sets to procedures.
  5. 🚧 TRY…CATCH & XACT_STATE() — Error handling patterns for robust T-SQL.