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.

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 :

CREATE FUNCTION function_name