/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

7 votes372 views2 answers
Mysql get year from date
SQL
5 votes385 views1 answer
Mysql last day of next month
SQL
1 vote348 views1 answer
Type int in mysql maxlenght
SQL
0 vote366 views1 answer
No query unable to fetch row sqlite
SQL
6 votes408 views2 answers
Foreign key sqlite3 python
SQL
-1 vote373 views3 answers
Compute age mysql
SQL
0 vote354 views1 answer
Mssql view column data type
SQL
1 vote346 views1 answer
Set statiscis on in sql server
SQL
7 votes354 views1 answer
Set sequence value oracle
SQL
0 vote362 views1 answer
Sql server query database space available
SQL