Revision as of 13:35, 20 February 2007 edit SmilesALot (talk \| contribs) 2,232 edits m Reverted edits by 203.100.78.117 to last version by Stolze ← Previous edit		Revision as of 14:41, 7 March 2007 edit undo ANNAfoxlover (talk \| contribs) Extended confirmed users 3,469 edits →Databases: fixed spelling 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. ~~Mirosoft~~Microsoft SQL Server, for example, allows the user to use .NET languages for this purpose. DB2 and Oracle support usel-defined functions written in C or Java programming languages. ==External links==

User-defined function: Difference between revisions