-- =============================================
-- create scalar function (fn)
-- =============================================
if exists (select ROUTINE_NAME, ROUTINE_TYPE
           from   INFORMATION_SCHEMA.ROUTINES 
           where  ROUTINE_NAME = N'<function_name, sysname, UDF_TST_Sum>'
             and  ROUTINE_TYPE = N'FUNCTION'
	drop function dbo.<function_name, sysname, UDF_TST_Sum>
go

/******************************************************************************

  dbo.<function_name, sysname, UDF_TST_Sum>

  purpose     : <purpose_of_udf, ,>

  author      : <author_of_udf, ,>
  created     : <creation_date, ,>

  history     :
    <creation_date, ,> - <author_of_udf, ,> - creation of the udf


******************************************************************************/
create function dbo.<function_name, sysname, UDF_TST_Sum> 
	(<@param1, sysname, @p1> <data_type_for_param1, , int>, 
	 <@param2, sysname, @p2> <data_type_for_param2, , int>)
returns <function_data_type, ,int>
as
begin
	<function_body, , return @p1 + @p2 >
--	eg.
--	declare @sum as int
--	select @sum = @p1 + @p2
--	return @sum
end
go