Scalar functions are functions that return a single value of a specific data type. They can be built-in, such as GETDATE(), LEN(), or UPPER(), or user-defined, such as dbo.GetEmployeeName(@ID ...