Calling UDFs from store procedure...

[Kris11]

How do I call a SQL Server User Defined function from a SQL Server Store Procedure? I have a function that returns a datetime and I want to call this in a store procedure to get the returned date time.

Thnx

Kris

 

[JamesLean]

In your SP:

DECLARE @dt datetime

SET @dt = myfunc()

--James

 

[SQLSister]

From Books Online:
When calling a scalar user-defined function, you must supply at least a two-part name:

SELECT *, MyUser.MyScalarFunction()
FROM MyTable

 

[JamesLean]

Oops, thanks SQLSister ;-)

--James

 

[Kris11]

Thanks Guys,

Yes, after JamesLean's suggestion when I tried calling function, it gave me a compilation error that "xxx function is not a recognized name", so I just tried adding

DECLARE @dt datetime

SELECT @dt = dbo.xxx( 1, 1 )

and it worked. Anyway thanks a lot for the help

Kris

 

[SQLSister]

Hey James, trust me I learned this one the hard way. I guess those are the lessons that stick with you, huh?