/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

5 votes223 views1 answer
Oracle nls instance
SQL
4 votes194 views6 answers
Sql select statement
SQL
3 votes193 views1 answer
Mssql remove column
SQL
0 vote192 views1 answer
Sql create table with datetime automatically
SQL
1 vote273 views1 answer
Top 10 rows in mysql
SQL
0 vote197 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote255 views1 answer
T-sql delete view if exists
SQL
3 votes219 views1 answer
Mysql replace string in table
SQL
14 votes195 views3 answers
Alter foreign key
SQL
1 vote199 views1 answer
SQL: merging multiple row data in string
SQL