Content deleted Content added
m Title |
Minor corrections |
||
Line 33:
Why isn't the title of this topic "User-defined function"? -- [[User:Mikeblas|Mikeblas]] 14:52, 18 June 2006 (UTC)
== Minor corrections ==
The samples should use standardized SQL and not some product-specific implementation. For example, the SQL standard does not use the '@' for variable names.
The statement that stored procedures cannot be evaluated on a per-row basis is not correct. First, it is possible to call stored procedures from a trigger and triggers can be declared as FOR EACH ROW. Thus, the body of a trigger is evaluated once-per-row, implying that a procedure call in the trigger body is invoked once per row. Next, some products (like DB2) allow that procedures can be called from within a function. Again, the procedure is invoked on a per-row basis.
The fact and concepts of table functions should be added.
The statement that stored procedures return a "set of rows" is too restrictive. A stored procedure may return result sets (multiple!), but it doesn't have to.
| |||