What are the advantages of using a stored procedure?

devquora
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

    Please Login or Register to leave a response.

    Related 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..