SQL Server : call function with parameter names

Question

Is there a way to call a SQL Server / T-SQL function using parameter names?

Something like:

select dbo.function1 (@par1 = 1, @par2 = 2)

It is possible to do so with stored procedures.

No, function parameters are position based<br/> stackoverflow.com/questions/8219163/… — Alex
– Alex, Commented May 12, 2016 at 0:21

Gaspa79 · Accepted Answer · 2016-05-12 00:53:30Z

4

No, there's no named arguments when calling functions I'm afraid. As you said before, there is in stored procedures.

answered May 12, 2016 at 0:53

Gaspa79

5,7066 gold badges44 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Silvère LHERMITE · Accepted Answer · 2022-11-08 16:53:35Z

3

Seems to be possible only with EXEC statement:

EXEC @ret = dbo.function1 @par1 = 1, @par2 = 2

answered Nov 8, 2022 at 16:53

Silvère LHERMITE

514 bronze badges