/SQL/Disadvantages of stored procedures sql

Disadvantages of stored procedures sql

Advantages of stored procedures sql

A Stored Procedure can be used as a 
modular programming which means create once, 
store and call for several times whenever
it is required. This supports faster execution.
It also reduces network traffic and
provides better security to the data.

Disadvantages of stored procedures sql

Disadvantage:
The only disadvantage of Stored Procedure 
is that it can be executed only in the
database and utilizes more memory in 
the database server.

Similar codes

7 votes273 views2 answers
N highest salary in sql
SQL
1 vote280 views1 answer
Oracle case
SQL
0 vote291 views1 answer
How to move a column to different spot mysql
SQL
0 vote290 views1 answer
How to input data as id in database sql c#
SQL
0 vote290 views1 answer
Sql case sttement with set
SQL
0 vote286 views1 answer
Restart sql server command line linux
SQL
0 vote277 views1 answer
Drop all tables in azure sql database
SQL
0 vote289 views1 answer
Teller stamp , bmo , PDF
SQL
5 votes278 views1 answer
Oracle columns in all_tables
SQL
0 vote298 views1 answer
Set root password mysql xampp
SQL