User Defined Functions in SQL
User Defined Functions are routines which performs calculation or operation to return a value or result set. It can accept input parameters too.
Types of User Defined Functions in SQL
- Scalar Function – Returns a single data value of the type defined in the RETURNS clause. The return type can be any data type except text,ntext, image, cursor, and timestamp.
- Table-Valued Function – Returns a table data type.