Skip to main content

Posts

Showing posts with the label sql server table valued function

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