/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 vote194 views1 answer
Describe table in sql
SQL
0 vote262 views1 answer
Run docker container with database as rds metabase
SQL
0 vote196 views1 answer
Setval postgres example table id
SQL
9 votes194 views3 answers
Find all tables with column name
SQL
0 vote205 views1 answer
Split first name and last name in sql
SQL
9 votes177 views2 answers
Get first 3 letters in sql
SQL
0 vote175 views1 answer
Oracle drop default value
SQL
2 votes230 views1 answer
Oracle Column Names of a table
SQL
0 vote182 views1 answer
Compare field sql server
SQL
0 vote207 views1 answer
"Hello User Name"
SQL