/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

11 votes338 views4 answers
Round in sql
SQL
3 votes347 views1 answer
Mysql set field unique
SQL
47 votes408 views6 answers
Add column mysql
SQL
1 vote364 views1 answer
Create another table from existing table sql oracle
SQL
17 votes357 views4 answers
Sort by mysql
SQL
1 vote386 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes355 views1 answer
Mysql clear screen
SQL
0 vote340 views1 answer
Mysql filter based on datediff
SQL
0 vote357 views1 answer
Mysql a from on this page has
SQL
1 vote364 views2 answers
Sql split string by space
SQL