Question

When to choose scalar function over inline table valued function?

(a) You want a single value as the result

(b) One or more row’s worth of data is expected

(c) You want multiple values as  result

(d) All of the mentioned

The question was posed to me in my homework.

I would like to ask this question from User Defined Functions topic in division Developing with SQL Server of SQL Server

Answer 1

Correct choice is (a) You want a single value as the result

To explain I would say: For an inline scalar function, there is no function body; the scalar value is the result of a single statement.