/SQL/Advantages 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 vote288 views1 answer
Search mysql database for column
SQL
0 vote351 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote284 views2 answers
Sqlalchemy core in clause
SQL
10 votes297 views2 answers
SQL rounding numbers
SQL
2 votes284 views1 answer
Removing view
SQL
11 votes271 views2 answers
Safe mode off mysql
SQL
0 vote288 views1 answer
ORA-00942
SQL
0 vote280 views1 answer
Mysql query problems and solutions
SQL
5 votes286 views1 answer
Sort order on two columns sql
SQL
0 vote277 views1 answer
Leftjoin in sql
SQL