/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 vote99 views1 answer
Mssql current date
SQL
0 vote109 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote119 views1 answer
Mysql regex select
SQL
0 vote116 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote106 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
-1 vote107 views1 answer
Mac mysql workbench console
SQL
0 vote60 views1 answer
Print sum of values sql
SQL
0 vote99 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote159 views3 answers
Osx stop mysql service
SQL
0 vote105 views1 answer
Hibernate show sql xml property
SQL