Skip to main content

Create Function in SQL Server

--==================================
--CREATE FUNCTION WITHOUT PARAMETER.
--==================================
CREATE FUNCTION AddFun()
RETURNS INT
AS BEGIN
DECLARE @Result AS INT
    SET @Result=2+3
RETURN @Result
END

--RESULT LOOKS LIKE,
PRINT test.dbo.AddFun() --IS 5