What is Stored Procedure?

In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that’s stored in the database in compiled form so that it can be shared by a number of programs.The use of stored procedures can be helpful in controlling access to data (end-users may enter or change data but do not write procedures), preserving data integrity (information is entered in a consistent manner), and improving productivity (statements in a stored procedure only need to be written one time).

Updated: November 23, 2016 — 12:01 pm


Add a Comment
  1. I am reading your blog daily. such a nice blog.
    Its very helpful for me ..

  2. thank you for your valuable comments

  3. thank you for your valuable comments

Leave a Reply

Your email address will not be published.

prabaweb.in Codelab- programming blog © 2017