Advantages and Disadvantages of Stored Procedure

0 votes
Hi!!

Can anyone tell me the advantages and disadvantages of the stored procedures?
Oct 9, 2018 in Database by Sahiti
• 6,370 points
20,236 views

2 answers to this question.

0 votes

Advantages:

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.

Disadvantage:

The only disadvantage of a Stored Procedure is that it can be executed only in the database and utilizes more memory in the database server.

answered Oct 9, 2018 by DataKing99
• 8,250 points
+1 vote
answered Apr 29, 2019 by anonymous

Related Questions In Database

0 votes
0 answers

SQL Differences between stored procedure and triggers

I'm having problems comprehending how a stored ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,020 points
693 views
0 votes
1 answer

What are the advantages of SQL?

Simple SQL queries can be used to ...READ MORE

answered Nov 8, 2018 in Database by DataKing99
• 8,250 points
5,934 views
+1 vote
2 answers

List few commands of DDL, DML, and DCL.

The list of commands is as follows:  Data ...READ MORE

answered Nov 12, 2018 in Database by Sahiti
• 6,370 points
120,012 views
0 votes
1 answer

What do ‘Record’, ‘Field’ and ‘Table’ mean in terms of a database?

You can refer to the following definitions ...READ MORE

answered Nov 12, 2018 in Database by Sahiti
• 6,370 points
21,849 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,250 points
2,234 views
+1 vote
0 answers

What are the advantages of SQL?

Dec 28, 2019 in Database by Yuth
• 130 points

closed Dec 30, 2019 by Kalgi 950 views
0 votes
1 answer

What are stored procedures?

The stored procedure is a collection of ...READ MORE

answered Aug 23, 2018 in Database by CodingByHeart77
• 3,750 points
1,257 views
0 votes
1 answer

What are stored procedures in database?

A stored procedure is a collection of ...READ MORE

answered Sep 6, 2018 in Database by CodingByHeart77
• 3,750 points
1,063 views
0 votes
1 answer

What does recursive stored procedure?

Recursive stored procedure refers to a stored ...READ MORE

answered Sep 27, 2018 in Database by Sahiti
• 6,370 points
15,131 views
0 votes
1 answer

How to use stored procedures in Tableau?

Hi Sindhu, Stored procedures are used to write ...READ MORE

answered Jun 10, 2019 in Tableau by Cherukuri
• 33,030 points
9,515 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP