CREATE FUNCTION

Create a user-defined function.

Syntax
      CREATE FUNCTION [schema.] function
         ( [@parameter [ AS ][type_schema.] parameter_data_type  [= default ]
            [ ,...n ]
           ])
      RETURNS
          return_clause...
      [;]


Key:
    function            Name of the function(s) to add.
    schema              The schema to which the user-defined function belongs.
    parameter_data_type The data type of the function (not timestamp) 
                        CLR functions, accept a limited range of data types.

The details of the return clause will vary for Scalar, Inline/Multistatement Table-valued, or CLR functions.
See SQL Server books online or the resources on the SQL Links page

"Form follows function" - Louis H. Sullivan

Related commands

ALTER FUNCTION
DROP FUNCTION
Equivalent Oracle commands: CREATE FUNCTION


 
Copyright © 1999-2024 SS64.com
Some rights reserved