Revision as of 14:41, 7 March 2007 edit ANNAfoxlover (talk \| contribs) Extended confirmed users 3,469 edits →Databases: fixed spelling ← Previous edit		Revision as of 14:48, 7 March 2007 edit undo Mikeblas (talk \| contribs) Administrators 82,210 edits m add internal link, fix typo 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 ~~usel~~user-defined functions written in C or Java programming languages. ==External links==

User-defined function: Difference between revisions