存储过程与函数 [英] stored procedure vs function

问题描述

我需要知道它们之间的区别，是否有人可以帮助

I need to know the difference between them please if anyone can help

推荐答案

两者之间的主要区别在于，函数提供了返回值的功能它何时完成，而存储过程却没有.但是，存储过程通常将用数据或out参数中的返回"值填充表. :)

The main difference between the two is that a function provides the ability to RETURN a value when it is completed, while a stored procedure does not. However stored procedures will usually populate tables with data, or ''return'' values in out parameters. :)

就像所有编程语言一样:函数返回一些有用的数据，这些数据可以在其他函数或程序中使用.一个过程是一个独立的小程序:它有一个开始和一个结束，并且它可以使用其他过程和功能来完成它的工作，但是返回的结果通常并不那么重要.过程可以是独立的东西，函数不能.

It''s like in all programming languages: a function returns some usefull data, which can the be used in other functions or programs. A procedure is a self contained mini-program: it has a start and an end, and, it may use other procedures and functions to do it''s job, but the what it returns is usually less important. A procedure can be a standalone thing, a function cannot.

这篇关于存储过程与函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！