Chapter 13: Implementing T SQL Routines

Question 1

What’s a scalar function?

Answer 1

It’s a function that just returns a single value (not a record set).

Question 2

What’s a table valued function (TVF)?

Answer 2

It’s a function that returns a record set (a bunch of rows).

Question 3

What are the types of table valued function?

Answer 3

(1) Inline Statement Table Valued Function (ITVF): it’s created from a single SELECT statement. It’s like a view but it accepts parameters.
(2) Multiline Statement Table Valued Function (MTVF): it can more than one statement in his structure (it’s like a stored procedure).