User-Defined Functions in Sql Server SSMS

[WWGD]

TL;DR Summary

Trying to figure out syntax problem with Syntax for function that takes as inputs two Real number and outputs the square root of the sum of the squares of the two numbers.

Hi, trying to write a user-defined function in SSMS Sql Server .that takes two Real numbers and outputs the square root of the
sum of their squares:

Line 152
CREATE FUNCTION dbo.Distance(@a Real, @b Real)
RETURNS Real
AS
BEGIN
SQRT(@a * @a + @b * @b)
END ;
GO

I re-checked the syntax for user-defined functions, but somehow I keep getting error messages .
Error Message:
Msg 102, Level 15, State 1, Procedure Distance, Line 5 [Batch Start Line 152]
Incorrect syntax near 'SQRT'.

any ideas?

 

[jedishrfu]

are you missing the RETURN stmt:

RETURN SQRT(@a*@a + @b*@b);

 

[WWGD]

are you missing the RETURN stmt:

RETURN SQRT(@a*@a + @b*@b);

Excellent, that did it. My Programmability folder runneth over. Thanks.

 

[jedishrfu]

Dont feel bad even the Scarecrow in the Wizard of OZ got the pythagorean theorem wrong.

https://woodycreative.com/wizard-of-oz-scarecrow-formula-not-so-good/#ll

 

[WWGD]

Dont feel bad even the Scarecrow in the Wizard of OZ got the pythagorean theorem wrong.

https://woodycreative.com/wizard-of-oz-scarecrow-formula-not-so-good/#ll

How hard could it be: Sum of squares of the sides equals the square of the Hypopotamus, isn't it?

 

[harborsparrow]

Because these are reals, depending on the relative size of input values, this computation might be subject to numerical overflow. So it might be helpful to insert some error handling in there.

 

[WWGD]

Because these are reals, depending on the relative size of input values, this computation might be subject to numerical overflow. So it might be helpful to insert some error handling in there.

Thanks, any refs?

 

[harborsparrow]

MS SQL uses TRY CATCH, but what to do if an error occurs depends on so many things. I would say Google it. You might also ask an AI chatbot for help coding that.