Benefits of using stored procedure

Question

Hi, What is benefits of using stored procedure over writing SQL command in any application? Thanks.

Satyapriya Nayak · Answer

Hi James, stored procedure Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basicaly like a Macro so when you invoke the Stored Procedure,you actually run a set of statements.Stored Procedure are the precomplied set of sql command. stored procedures means containing a precompiled block of code.if we call stored procedures they need not compiled,only execution takes place.with this advantage ,work on database is less. with these sps we can perform business logics. SP are compiled and their execution plan is cached and used again to when the same SP is executed again Please refer the below link http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/ Thanks

Priya Linge · Answer

Hi, 1.StoredProcedures can improve performance. 2.StoredProcedures can reduce network traffic. 3.We don't have to implement your SQL statements into every application that talks to the database. please check below link.. http://www.codeguru.com/forum/showthread.php?t=337736 Hope this will help you. Thanks.

Benefits of using stored procedure

Answers (2)