Syntax

Berikut merupakan syntax dasar dari SQL Function.

CREATE FUNCTION cityCon
(
 @FirstName varchar(50),
 @LastName varchar(50)
)

RETURNS varchar(101)

AS

BEGIN 
    RETURN (SELECT @FirstName + ' '+ @LastName);
END;


// untuk memanggil
SELECT dbo.cityCon(nama,nama) from city;

CREATE FUNCTION ReturnSite
( @site_id INT )

RETURNS VARCHAR(50)

AS

BEGIN
   DECLARE @site_name VARCHAR(50);

   IF @site_id < 10
      SET @site_name = 'makersinstitute.id';
   ELSE
      SET @site_name = 'lalala.com';

   RETURN @site_name;
END;


// untuk memanggil
SELECT dbo.ReturnSite(8);