disadvantages of stored procedures sql

Solutions on MaxInterview for disadvantages of stored procedures sql by the best coders in the world

showing results for - "disadvantages of stored procedures sql"
Simone
31 Apr 2017
1Disadvantage:
2The only disadvantage of Stored Procedure 
3is that it can be executed only in the
4database and utilizes more memory in 
5the database server.
Emer
09 Sep 2018
1A Stored Procedure can be used as a 
2modular programming which means create once, 
3store and call for several times whenever
4it is required. This supports faster execution.
5It also reduces network traffic and
6provides better security to the data.