Syntax of Function
CREATE FUNCTION YourFunction_Name()
RETURNS Decimal(6, 2) // Set your return type
AS
BEGIN
// your calculation here.
RETURN 944.22 // return your value
END;
GO
Below is the example of Function :
CREATE FUNCTION YourFunction_Name()
RETURNS Decimal(6, 2)
AS
BEGIN
RETURN 944.22
END;
GO