Stored Procedure

Stored Procedure- A precompiled routine of code stored as part of a database and callable by name.

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 11-Feb-2009 14:09

---

These advertisers support this free service

---

Stored Procedure - A stored procedure is SQL code placed in a special area inside a DBMS. Triggers are specialized stored procedures.

[Category=Data Governance ]

Source: The Data Governance Institute, 26 December 2009 10:34:23, http://www.datagovernance.com/glossary-governance/

---

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

Related glossary terms: The Open Group, Dynamic Structured Query Language (SQL), autonomous transaction, ColdFusion Markup Language (CFML), Java Database Connectivity (JDBC), Query-by-Example / Query by Example (QBE), Open Database Connectivity (ODBC), foreign key

[Category=Data Management ]

Source: WhatIs.com, 11 September 2013 09:20:03, http://whatis.techtarget.com/glossary/Data-and-Data-Management