A table-valued function acts like a view with the added benefit of being parameterized. For this example, we create a table-valued function using the Employees table.

CLR Table-Valued Functions [!INCLUDE SQL Server] A table-valued function is a user-defined function that returns a table. Beginning with [!INCLUDE ssVersion2005], [!INCLUDE ssNoVersion] extends the ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...

To use table-valued parameters you first need, in SQL Server Manager, to define a table type to your database. This example defines a table type called JobSpecifications with two columns called ...

However, you can greatly improve the performance by converting the scalar function to a table-valued function and using a CROSS APPLY in the query.

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.