midT-SQL
What is a SQL function?
Updated May 17, 2026
Short answer
Reusable computation returning a value or table.
Deep explanation
Scalar functions return single values, table functions return datasets.
Real-world example
Tax calculation function.
Common mistakes
- Using scalar functions in large queries.
Follow-up questions
- Function vs procedure?
- Deterministic functions?