Mention the uses of stored procedures.

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:

  • Stored procedures are often used as access control mechanism and for data validation.
  • The logic applied in this application is centralized and is stored in the application.
  • Procedures are used to process the huge amount of data for complex procedures and functionalities and for logic implementation access of their data.
  • These procedures are used to store data in them and can be accessed by procedures.
  • They support modular programming.
  • Faster execution takes place.
  • It can also be used as a security mechanism.
  • They are used for reducing network traffic.

    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

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

    Stored procedures Interview questions

    What are the advantages of using a stored procedure?

    The following are the advantages of using a stored procedure: – It reduces the network usage between the client and t..