A table-value function normally returns a set of rows ... inline TVFs are inlined and optimized as normal. Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined.

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions ... that I plan on using to handle my table valued parameter. The following procedure accepts ...