/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

1 vote130 views1 answer
Oracle finding duplicate records
SQL
4 votes139 views1 answer
Select nls_date_format
SQL
0 vote138 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote147 views1 answer
Select from 3 tables one is empty
SQL
4 votes164 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote182 views1 answer
Mysql command line top 10
SQL
0 vote154 views1 answer
Sql use with to get value counts and percentages
SQL
16 votes153 views3 answers
T-SQL Add Column
SQL
0 vote144 views1 answer
Nueva tabla mysql
SQL
0 vote145 views1 answer
Exec procedure oracle
SQL