Question

Which of the following does not return a table variable?

(a) System-defined function

(b) Scalar Function

(c) Inline Table-Valued Function

(d) Multi-Statement Table-Valued Function

This question was addressed to me in class test.

Question is taken from User Defined Functions topic in section Developing with SQL Server of SQL Server

Answer 1

Right option is (b) Scalar Function

Explanation: User-defined multi-statement table-valued function returns a table variable as a result of actions performed by the function.