/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 vote318 views1 answer
Postgres rename database
SQL
5 votes252 views2 answers
Oracle show procedures
SQL
0 vote278 views1 answer
How to remove quotes from a string in ssis load file
SQL
11 votes287 views3 answers
Python sqlite3 create table if not exists
SQL
17 votes280 views6 answers
Change column name in sql
SQL
0 vote267 views1 answer
Where date in datetime mysql
SQL
37 votes261 views3 answers
Duplicate records in sql
SQL
1 vote265 views2 answers
How to add amount between date in sql
SQL
1 vote291 views1 answer
Oracle see column type
SQL
0 vote264 views1 answer
With_for_update sqlalchemy
SQL