/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 vote301 views1 answer
Capabilities of sql select statements
SQL
9 votes251 views2 answers
Default number in sql
SQL
0 vote237 views1 answer
Sql truncate table referencing itself
SQL
0 vote301 views2 answers
Sql having multiple conditions
SQL
2 votes323 views1 answer
Capitalize 1st letter in sql server
SQL
7 votes315 views2 answers
Sql remove duplicates based on column
SQL
1 vote278 views1 answer
Oracle schema size
SQL
0 vote272 views1 answer
Except in sql
SQL
0 vote320 views1 answer
Get substract count sql
SQL
0 vote256 views1 answer
Python mysql query where
SQL