A table-value function normally returns a set of rows, ... Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined. ... Some multi-statement UDFs can also be inlined.