What is the importance of Store procedure in database ?

[ankitasharma123]

Hi







What is the importance of Store procedure in database ?

[adlerdale]

A stored procedure is a precompiled set of Structured Query Language (SQL) statements that can be shared by a number of programs. There are important features of store procedure such as:

• Easy to maintain
• Independently test the applications
• it contains speed, security and well optimized.

[edwina]

Nice information.

[ankitasharma123]

Thanks for reply.

[Dazzy Hayden]

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.

[Dazzy Hayden]

Hi All,
The store procedure helps to build powerful database applications, stored procedures provide several advantages including better performance, higher productivity, ease of use, and increased scalability.

[johnstark166]

To help you build powerful database applications, stored procedures provide several advantages including better performance, higher productivity, ease of use, and increased scalability.

[tomfam]

In DBMS, Store procedure is a set of structured query language. It's advantage such as avoid redundant coding, increasing scalability, security,maintainability,replication and gives better performance.

[pihu]

SP is a pree-compiled SQL statement that execute server side , and major benefit is it avoid sql injection and save time.

[Asif Ali]

Stored Procedure is very helpful to stored record with different tables and saved your time.

[globalcscp]

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDMS). Such procedures are stored in the database data dictionary.


Typical uses for stored procedures include data validation (integrated into the database) or access control mechanisms. Furthermore, stored procedures can consolidate and centralize logic that was originally implemented in applications. Extensive or complex processing that requires execution of several SQL statements is moved into stored procedures, and all applications call the procedures. One can use nested stored procedures by executing one stored procedure from within another.

[pxl]

Some of the main use of the stored procedure are improve the stability of the application,it enable the strict security model..

[komal14]

Stored procedures are compiled once and stored in executable form, so procedure calls are quick and efficient. Executable code is automatically cached and shared among users. This lowers memory requirements and invocation overhead.