text: -- ====================================================================
  -- Create Scalar Function Template for Azure Synapse Analytics Database
  -- ====================================================================
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  -- =============================================
  -- Author:      <Author, , Name>
  -- Create Date: <Create Date, , >
  -- Description: <Description, , >
  -- =============================================
  CREATE FUNCTION <Scalar_Function_Name, sysname, FunctionName>
  (
      -- Add the parameters for the function here
      <@Param1, sysname, @p1> <Data_Type_For_Param1, , int>
  )
  RETURNS <Function_Data_Type, ,int>
  AS
  BEGIN
      -- Declare the return variable here
      DECLARE <@ResultVar, sysname, @Result> <Function_Data_Type, ,int>
  
      -- Add the T-SQL statements to compute the return value here
      SET <@ResultVar, sysname, @Result> = <@Param1, sysname, @p1>
  
      -- Return the result of the function
      RETURN <@ResultVar, sysname, @Result>
  END
  GO
  
  