请告诉我这些差异是正确还是错误： [英] Please tell me these differences are correct or wrong:

问题描述

请告诉我这些差异是对还是错：

Please tell me these differences are correct or wrong:

Procedure can return zero or n values whereas function can return one value which is mandatory.
Procedures can have input/output parameters for it whereas functions can have only input parameters.
Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
Functions can be called from procedure whereas procedures cannot be called from function.
Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.
We can go for transaction management in procedure whereas we can't go in function.
Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.

推荐答案

存储过程与用户定义函数之间的差异 [ ^ ]包含所有答案。

Difference between Stored Procedure and User Defined Functions [^] has all the answers.

参考以下链接



http://shivasoft.in/view_tutorial.php?id=130 [ ^ ]

最好阅读这个



http://www.dotnetspider.com/resources/35276-Difference -between-Stored-Procedure-Function.aspx [ ^ ]



除了从这个门户网站喂勺外，不要这样做。

Better to read this

http://www.dotnetspider.com/resources/35276-Difference-between-Stored-Procedure-Function.aspx[^]

Don''t except spoon feeding from this portal.

这篇关于请告诉我这些差异是正确还是错误：的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！