/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 vote162 views1 answer
Safe mysql
SQL
0 vote177 views1 answer
Oracle service name view
SQL
0 vote167 views1 answer
Contraint default SQL
SQL
6 votes157 views1 answer
Oracle rank() over (partition)
SQL
0 vote180 views1 answer
Write sql query to show the details start from digit
SQL
0 vote163 views1 answer
Sql include rows with 0 values
SQL
1 vote184 views1 answer
Rails run native ssql query
SQL
0 vote166 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote185 views1 answer
Oracle sql add column auto generated value
SQL
8 votes207 views6 answers
Insert command in sql
SQL