/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

50 votes173 views6 answers
Sql duplicate rows
SQL
0 vote102 views1 answer
Oracle last character of string
SQL
0 vote100 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote109 views1 answer
How to to get current date in sql
SQL
0 vote122 views2 answers
Null value in column violates not-null constraint
SQL
0 vote106 views1 answer
Wordpress database query change url
SQL
0 vote117 views1 answer
Mysql procedure between two tables
SQL
0 vote103 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote129 views1 answer
Ubuntu connect to mssql database
SQL
9 votes147 views1 answer
No sql
SQL