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
Answer:A
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
Explanation:For an inline scalar function, there is no function body; the scalar value is the result of a single statement.