/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 vote341 views1 answer
What is logical database schema
SQL
1 vote335 views2 answers
Oracle replace
SQL
0 vote385 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote342 views1 answer
Sql server express download
SQL
2 votes357 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
3 votes358 views3 answers
C# sql select
SQL
0 vote349 views1 answer
Use between operator in mysql
SQL
0 vote360 views1 answer
Sql character index
SQL
6 votes359 views1 answer
Phpmyadmin password root
SQL
1 vote353 views1 answer
Get parameter value in mysql trigger
SQL