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 ...

A table-value function normally returns a set of rows, but it could be written to only return one. At which point the CROSS APPLY operator can be used to simulate a normal scalar function call.