/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

15 votes189 views5 answers
If null mysql
SQL
0 vote183 views1 answer
Mysql set column equal to another automatic
SQL
1 vote194 views3 answers
How to truncate foreign key constraint table
SQL
0 vote182 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote210 views1 answer
Bitmap join index
SQL
13 votes191 views3 answers
Insert mysql ifile nto database
SQL
0 vote181 views1 answer
How to display value of variable in mysql
SQL
2 votes178 views1 answer
Import database in mysql command line xampp
SQL
0 vote185 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote186 views1 answer
Search from comma separated values in sql server
SQL