Benefits of using stored procedure

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

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.