• A table-valued function is a function that returns data of table type. In this example we will create an inline table-valued function that will retrieve records of all the students whose DOB is less than the DOB passed to the function.
• The following example creates an inline table-valued function (TVF) in the AdventureWorks2012 database. The function takes one input parameter, a customer (store) ID, and returns the columns ProductID, Name, and the aggregate of year-to-date sales as YTD Total for each product sold to the store.

EXAMPLE: - CREATE FUNCTION employee (@e_id int)

EXECUTION: - SELECT * FROM employee (5);