Functions
What are Functions
A function accepts inputs in the form of parameters and returns a value. These functions perform a variety of tasks .
Functions contain string, numeric, date, conversion, and some more advanced functions.
We can use a function almost anywhere that we would use a table or column. Functions can even be used in constrains, computed columns, joins, WHERE clauses, or even in other functions.
Syntax :
- Creating a Function :
CREATE FUNCTION function_name
-
Altering a Function :
ALTER Function function_name
-
Deleting a Function :
DROP Function function_name