The benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include: They allow modular programming. They allow faster execution.
They can reduce network traffic. They can be used as a security mechanism.
Determine when to use stored procedures vs. SQL in the code Stored procedures in SQL Server are similar to procedures in other programm.....
원문 링크 : 프로시저 언제 사용해야 하나?