NULL handling, ROWS vs RANGE, FOR JSON, JSON_MODIFY, THROW vs RAISERROR, @@ROWCOUNT gotchas, and dynamic SQL risks!