Using named parameters in Table Valued Function

Question

Is there a way to use named parameters with table valued functions ? My users insist to use them with their interface to my db objects.

Answer 1

No, you can't do that. Unlike stored procedures where you can use named parameters the parameters in table valued functions are strictly position-based.

Answer 2

It seems it has changed with SQL-Server 2016. Named parameter in T-SQL function is supported in SQL Server 2016 https://scribnasium.com/2017/01/named-parameters-in-t-sql-functions/