哪一个最佳?单操作存储过程或多操作存储过程 [英] Which one is best?stored procedure for single operation or stored procedure for multi operation

问题描述

Hai朋友，

我正在开发基于Windows和Web的学校项目.有人能告诉我哪个是最好的吗?是针对每个dml操作(如插入)的存储过程，还是针对多个dml操作(如插入，更新，删除，选择)的存储过程.我有很多表，所以是否要为每个dml操作创建单独的过程?
如果是这样，那么存储过程的数量会增加，这可能会导致数据库进程变慢.请帮助我找到正确的方法.


预先感谢

Hai friends,

I am developing windows and web based school project.can anybody tell me which one is best?stored procedure for each and every dml operation like(insert) or one store procedure for multi dml operation like(insert,update,delete,select). I have many tables so whether i would create seprate procedure for every dml operation?
if so then number of store procedure increased and this could lead to slow down the database process.please help me to find correct way.


Thank in advance

推荐答案

单个操作.您不想传递一个开关，如果它是错误的，它将删除而不是更新.

Single operation. You don''t want to be passing in a switch and if it''s wrong, it deletes instead of updates.

这篇关于哪一个最佳?单操作存储过程或多操作存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！