/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

4 votes195 views1 answer
Id increment ms sql server
SQL
1 vote208 views1 answer
How to delay stored procedure execution in sql server
SQL
3 votes169 views1 answer
Oracle nextval
SQL
1 vote201 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote255 views1 answer
Osm2pgsql mac
SQL
0 vote224 views1 answer
Stored function in sql
SQL
0 vote203 views1 answer
Kotlin sqlite delete row
SQL
0 vote186 views1 answer
Contact mysql column field
SQL
0 vote205 views1 answer
Less than date query sqlachemy
SQL
0 vote213 views1 answer
Stratified sampling sql
SQL