SQL Passing arguments for a function by named parameters

Question

I am using SQL Server 2012. I know that with stored procedures you can pass arguments by name.

EXEC PROC_A @p_para = 'Test'

Can one do the same with a function?

SET @iID = [dbo].[FUNC_GET_INTEGRITY_ID](@p_strSearchForValue = '805-2020', @p_strSearchForValue2 = DEFAULT, @p_tinProcessID = 1, @p_bitRunStatic = 1)

If this is not the correct syntax, what is it or is there another way to do this.

Would be nice to see the named parameters as a form of self documentation.

Found this that indicates it might never be coming :-) connect.microsoft.com/SQLServer/feedback/details/361449/… — SMM
– SMM, Commented Jun 22, 2016 at 19:07

CarloC · Accepted Answer · 2016-06-22 19:45:39Z

3

Here is the correct syntax for executing the function by named parameters (see Arulkumar's comment link above for details).

EXEC @iID = [dbo].[FUNC_GET_INTEGRITY_ID] @p_strSearchForValue = '805-2000', @p_strSearchForValue2 = DEFAULT, @p_tinProcessID = 1, @p_bitRunStatic = 1

Note that there are no brackets used as would be in a SET or SELECT statement.

answered Jun 22, 2016 at 19:45

CarloC

15513 bronze badges

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

Collectives™ on Stack Overflow

SQL Passing arguments for a function by named parameters

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related