Pass Named Params To A Function

[BenSCooper]

Hi All,
I have a user defined function (SQL 2005) that expects a number of parameters. I'm wondering if there is any way to pass the params to this function by name, as is possible when calling stored procedures?
E.g. SELECT * FROM [FunctionName] (@Param1 = 'Value', @Param2 = 'Value')

It's not a huge deal, but I think it would make my coding slightly clearer and guard against passing params in the wrong order.

Many Thanks
Ben Cooper

 

[PWise]

how about calling it from a stored procedure


Create procedure

@pram1
@pram2

As

Select * from functionname(@pram1,@pram2)

Return

 

[markros]

Sounds like a good wish for Connect.

PluralSight Learning Library