Content deleted Content added
User defined functions are not limited to SQL systems |
→Databases: overlap with stored procedure |
||
Line 8:
==Databases==
In some databases, a UDF or [[stored procedure]] is an [[extension (computing)|extension]] to the [[database server]] (like [[MySQL]]) that can be compiled for use in an [[SQL]] [[database query language|query]]. For example, sometimes it may be necessary to obtain a [[random]] number for use as a [[primary key]] (a function that MySQL does not internally support). In this case, a new external function could be written and compiled to accomplish this task.
One sample of such a query could be: <code>SELECT GETRANDOMKEY();</code>.
Essentially, this external function becomes part of the server itself. This can also known as a [[user exit]] (e.g. in the [[Adabas]] database)
==External links==
| |||