Home / 3rd highest salary in sql server / check view exists sql server / EXISTS in SQL Server / sql server table valued function / Create Function in SQL Server

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

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2