What are the advantages of using a stored procedure?
devquora
Posted On: Feb 22, 2018
The following are the advantages of using a stored procedure: –
- It reduces the network usage between the client and the server and an immediate processing is performed on the database server. It hence reduces the unnecessary data transfer.
- Security is improved and the user access to the stored procedure is managed by the administrator.
- Development cost reduces and reliability increases.
- It improves the performance of the database.
- These are used to encapsulate the logic and hence the code can be changed without affecting the clients.
- The access to other database objects becomes more secure.
- SQL injection attacks can be avoided using this.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Stored Procedures Interview Questions
What do you understand by a stored procedure?
The group of SQL statements which are or have been stored in the server database is known as a stored procedure. Input ..
Stored Procedures Interview Questions
Mention the uses of stored procedures.
Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:Stored p..
Stored Procedures Interview Questions
What are the types of stored procedures in an SQL server?
The types of stored procedures present in an SQL server are listed as follows: – User-defined stored procedures– th..