<div>
sure.<br />
<br />
ex:<br />
<br />
CREATE FUNCTION [dbo].[function1] &nbsp; ( @pvar1 varchar(30), &nbsp;@pvar2 varchar(30), @pvar3 int )
</div>


<div>
Assuming you mean user defined functions, yes.<br />
<a href="http://www.sqlteam.com/article/user-defined-functions" rel="ugc">http://www.sqlteam.com/article/user-defined-functions</a>
</div>


<div>
NO<br />
<br />
create function dbo.namedfun (@i int , @j int) returns int<br />
as begin<br />
return @i+@j<br />
end<br />
<br />
select dbo.namedfun (1, 2)<br />
select dbo.namedfun (@i=1, @j=2)<br />

</div>


<div>
A more complete sample<br />
One line will fail as indicated<br />

<pre><code class="code-10 nolinks" id="code-1293661"><span>use tempdb</span>
<span>GO</span>
<span>create function dbo.namedfun (@i int , @j int) returns int</span>
<span>as begin</span>
<span>return @i+@j</span>
<span>end</span>
<span>GO</span>
<span>select dbo.namedfun (1, 2) -- ok</span>
<span>GO</span>
<span>select dbo.namedfun (@i=1, @j=2) -- fail</span>
<span>GO</span>
<span>drop function namedfun</span>
<span>GO</span>
<span>create proc dbo.namedproc @i int , @j int</span>
<span>as</span>
<span>select @i * 10 + @j</span>
<span>GO</span>
<span>exec dbo.namedproc 1, 2 -- ok, result is 12</span>
<span>GO</span>
<span>exec dbo.namedproc @j=1, @i=2 -- ok, result is 21, not 12</span>
<span>GO</span>
<span>drop proc namedproc</span>
<span>GO</span>
</code></pre>
</div>


<div>
So we can't call a function with named arguments like we can with a stored procedure. And, from what I have learned since posting the question, ALL the parameters have to ALWAYS be passed.<br />
<br />
Correct?<br />
<br />
Kevin
</div>


<div>
cyberkiwi,<br />
<br />
Kewl!<br />
<br />
Sort of like overloading. I like.<br />
<br />
Thanks!<br />
<br />
Kevin
</div>


<div>
<div class="content wysiwyg-content">
Can named parameters be used in a function call as they can be in a stored procedure call?<br />
<br />
Kevin
</div>
</div>


Can named parameters be used in a function call as they can be in a stored procedure call?

Kevin

SQL Server Named Parameters

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.