Optional Parameter

[chandru_244]

Hi,
Does Used Defined Functions in MS Sql Server take Optional parameters like Stored Procedures

Give me an example
Tx in advance

Rgds,
Chandu

[olivthill]

User (not "Used") Defined Functions can take parameters, but these parameters are required if they are defined.
Example:CREATE FUNCTION get_sum_major (@inmajor varchar(40))
RETURNS money
AS
BEGIN
DECLARE @sum_paid money
SELECT@sum_paid = sum(tuition_paid)
FROM student_admin.student
WHERE major = @inmajor
RETURN @sum_paid
END

[f_eriksen]

well, actually you can. but, you need to be aware of the parameter, and assign it the value "default"

Quick example:

create function dbo.fnc_test(@a int, @b int = 1)
returns int
begin
declare @r int

set @r = @a + @b

return @r
end
go

select dbo.fnc_test(10, DEFAULT) as test
go


HTH

Fridthjof