/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

2 votes202 views1 answer
Mysql create user with remote access
SQL
0 vote143 views1 answer
WHERE not regex in SQL
SQL
2 votes120 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote148 views1 answer
Hashpass
SQL
0 vote125 views1 answer
Sql database connectivity
SQL
0 vote134 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote202 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote116 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote158 views1 answer
How not to sort by average rating
SQL
0 vote135 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL