User-Defined Table-Valued Functions (TVFs)

TVFs can accept input parameters, execute a single SELECT statement, and return the result as a table-typed value. For more information, see CREATE FUNCTION (TVF).