Revision as of 14:48, 7 March 2007 edit Mikeblas (talk \| contribs) Administrators 82,210 edits m add internal link, fix typo ← Previous edit		Revision as of 14:50, 7 March 2007 edit undo Mikeblas (talk \| contribs) Administrators 82,210 edits m →Databases: add internal link Next edit →
Line 35: User-defined functions should not be confused with [[stored procedure]]s. Stored procedures allow the user to group a set of SQL commands. A procedure can accept parameters and execute its SQL statements depending on those parameters. A procedure is not an [[expression (programming)\|expression]] and, thus, cannot be used like user-defined functions. Some database management systems allow the creation of user defined functions in languages other than SQL. [[Microsoft SQL Server]], for example, allows the user to use [Microsoft .NET Languages\|.NET languages]] for this purpose. DB2 and Oracle support user-defined functions written in C or Java programming languages. ==External links==

User-defined function: Difference between revisions