/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

0 vote228 views1 answer
Mysql, how to query the table comments?
SQL
2 votes176 views1 answer
Apex date today add days
SQL
0 vote178 views3 answers
Sql server import json
SQL
-1 vote187 views1 answer
Mysql order by on condition
SQL
0 vote174 views1 answer
Sql make sure every user is unqiuew
SQL
104 votes277 views2 answers
Like in mysql
SQL
0 vote180 views1 answer
Sql count null values in all columns
SQL
0 vote175 views1 answer
Oracle current timestamp
SQL
0 vote182 views2 answers
What is rownum in oracle
SQL
0 vote164 views1 answer
Double in sql server example
SQL