Hola Friends! Today we will learn about various user defined functions present in SQL. So far, we have studied lots of system functions : IsDate, Rand(), round() etc. To gather more information about these system functions, please refer my post Mathematical functions in SQL and Date time functions in SQL.
SQL provides us a feature of programmability wherein it provides system functions as well as lets user create functions of three types:
- Scalar functions
- InLine Table Valued functions
- Multi Statement table valued functions
Each type of sql function is of different use and one should have a proper understanding of all these function types.
If you are new to SQL, please check SQL basics and SQL mathematical