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

Now generally available, SQL Server 2022's feature set brings ... traditional anti-patterns like user-defined scalar functions and table-valued functions in SQL Server 2017 and 2019.