The Broken UDF

Question

The Broken UDF

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 27, 2022 at 12:00 am

#4064899

Comments posted to this topic are about the item The Broken UDF

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

richardmgreen1 SSChampion Points: 10351 More actions · Answer 1

Hi Steve

Just had a look at todays question and it appears the error message is missing so you can't try to pick the correct answer.

Am I missing something?

Regards

Richard

Erwin Oosterhoorn SSCrazy Points: 2316 More actions · Answer 2

I have this code on SQL Server 2017:CREATE FUNCTION AddOne

(@i INT)

RETURNS INT

AS

BEGIN

DECLARE @result INT;

SELECT @result = @i + 1;

RETURN @result;

END;

GO

SELECT AddOne(3)

When I execute this, I get the following error: Msg 195, Level 15, State 10, Line 11 'AddOne' is not a recognized built-in function name. What is wrong?

(From the email)

richardmgreen1 SSChampion Points: 10351 More actions · Answer 3

Thanks for that.

In Chrome, I don't get the "Msg 195, Level 15, State 10, Line 11 'AddOne' is not a recognized built-in function name." bit.

Regards

Richard

IndyMike SSC Enthusiast Points: 159 More actions · Answer 4

That's what I get in 2019. Don't have a instance of 2017 loaded to see if it's the same.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Weird, the error is in the question editor, but not showing on the site. I've reformatted it to appear.

The issue is a UDF requires a two part name.