/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

1 vote242 views2 answers
Sql insert timestamp
SQL
0 vote252 views1 answer
Consecutive numbers sql
SQL
0 vote229 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
1 vote209 views1 answer
Postgresql convert text to float
SQL
0 vote240 views1 answer
SAP Return
SQL
0 vote229 views1 answer
Date on SQL
SQL
0 vote245 views4 answers
Open mysql port bitnami tomact
SQL
0 vote225 views1 answer
Postgres enumerated type
SQL
0 vote220 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
3 votes251 views3 answers
Update con select postgresql
SQL