Content deleted Content added
RevRagnarok (talk | contribs) m →Minor corrections: be bold! |
m not incorrect |
||
Line 44:
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.{{unsigned|141.35.14.130}}
:[[WP:BOLD|Be bold!]] This is not something I know a lot about, feel free to clean it up! — <span style="text-decoration: none;">[[User:Revragnarok|<font color="#696969">RevRagnarok</font>]] <sup>[[User_talk:Revragnarok |Talk]] [[Special:Contributions/Revragnarok|Contrib]]</sup></span> 20:11, 28 July 2006 (UTC)
::As far as I can tell, the SQL standard further does not include user defined functions--so variable syntax doesn't seem relevant. You might want to add another example or a description to the article explaining this.
::The point the article is trying to make is that a function is invoked within a statement once per row within the statement. A stored procedure can't be evaluated once per row within a statement -- unless you wrap it in another function. (Note that the body of a triger, declared FOR EACH ROW or not, is semantically equivalent to a function.) If you can find a more accurate way to express that, let us know! -- [[User:Mikeblas|Mikeblas]] 20:24, 28 July 2006 (UTC)
| |||