|
|
Error Message
Server: Msg 195, Level 15, State 10, Line 1
Function Name is not a recognized function name.
Causes:
This error is encountered when invoking a scalar-valued user-defined function using just the single-part name of the function and not including the owner.
|
To illustrate, let’s say you have the following scalar-valued user-defined function:
CREATE FUNCTION [dbo].[ufn_Greatest]
( @pInt1 INT, @pInt2 INT )
RETURNS INT
AS
BEGIN
IF @pInt1 > @pInt2
RETURN @pInt1
RETURN @pInt2
END
GO
Invoking this scalar-valued user-defined function using just the single-part name of ufn_Greatest will generate the error:
SELECT ufn_Greatest ( [FirstTestScore], [SecondTestScore] ) AS [HigherScore]
FROM [dbo].[StudentScores]
Server: Msg 195, Level 15, State 10, Line 1
'ufn_Greatest' is not a recognized function name.
Solution / Work Around:
When invoking scalar-valued user-defined functions, always use the two-part name of the function, which is basically calling the function with the owner name as can be seen from the following example:
SELECT [dbo].[ufn_Greatest] ( [FirstTestScore], [SecondTestScore] ) AS [HigherScore]
FROM [dbo].[StudentScores]
|