Revision as of 14:50, 7 March 2007 edit Mikeblas (talk \| contribs) Administrators 82,210 edits m →Databases: add internal link ← Previous edit		Revision as of 14:05, 11 March 2007 edit undo RevRagnarok (talk \| contribs) Extended confirmed users 10,037 edits m Misc minor clean up using AWB Next edit →
Line 33: * SQL-data access - tells the database management system whether the function contains no SQL statements (NO SQL), contains SQL statements but does not access any tables or views (CONTAINS SQL), reads data from tables or views (READS SQL DATA), or actually modifies data in the database (MODIFIES SQL DATA). 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