SQL CREATE FUNCTION
Syntax
- CREATE FUNCTION function_name ( [list_of_paramenters] ) RETURNS return_data_type AS BEGIN function_body RETURN scalar_expression END
Parameters
| Argument | Description |
|---|---|
| function_name | the name of function |
| list_of_paramenters | parameters that function accepts |
| return_data_type | type that function returs. Some SQL data type |
| function_body | the code of function |
| scalar_expression | scalar value returned by function |
Remarks
CREATE FUNCTION creates a user-defined function that can be used when doing a SELECT, INSERT, UPDATE, or DELETE query. The functions can be created to return a single variable or a single table.
