存储过程的主要目的是什么 [英] what is the main purpose of stored procedure

问题描述

在提供sql语句时使用它的主要优点是什么?

what is its main advantage while using when we are provided with sql statements

推荐答案

首先请参考以下内容:
http://mukund.wordpress.com/2005/10/14 /advantages-and-disadvantages-of-stored-procedure/ [ http://www.java-samples.com/showtutorial.php?tutorialid=1000 [ ^ ]
http ://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic =/com.ibm.db2.udb.dc.doc/dc/c_spbenefits.htm [ ^ ]

refer first these:
http://mukund.wordpress.com/2005/10/14/advantages-and-disadvantages-of-stored-procedure/[^]
http://www.java-samples.com/showtutorial.php?tutorialid=1000[^]
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.dc.doc/dc/c_spbenefits.htm[^]

存储过程的主要目的是可重用性.
存储过程在服务器上执行.
存储过程已预先编译.
存储过程的优点

The main purpose of Stored procedure is reusability.
Stored procedure are executed on server.
Stored procedures are pre-compiled.
Benifits of Stored Procedure

使用存储过程可以更好地控制公开的功能.当多个应用程序使用同一个数据库时，这会获得更多收益.您可以授予对仅显示必要功能的某些存储过程的访问权限.数据的存储方式定义在一个中心位置，如果需要，可以立即为所有应用程序固定.存储过程通常更快，因为服务器已经知道您要问什么样的问题.

祝你好运！

Using stored procedures gives more control over the functionality exposed. This gets more when multiple applications use the same database. You can grant access to certain stored procedures that expose only the necessary functionality. The way data is stored is defined in a central place and if needed can therefor be fixed for all applications at once. Stored procedures are generally faster because the server already knows what kind of questions you are going to ask it.

Good luck!

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