Stored procedures definition of Stored procedures in the Free Online Encyclopedia.

stored procedure

In a database management system (DBMS), it is an SQL program that is stored in the database which is executed by calling it directly from the client or from a database trigger. When the SQL procedure is stored in the database, it does not have to be replicated in each client. This saves programming effort especially when different client user interfaces and development systems are used. Triggers and stored procedures are built into DBMSs used in client/server environments.

(database)

stored procedure - A subroutine stored in a database and executed by the database management system. The subroutine may be written in the same language in which the database is queried and may be precompiled to improve performance.

Typically a stored procedure encapsulates some business process. Performing this on the database server avoids the network overhead of transferring input data to the client for processing. This would be particularly significant if processing lots of data and returning a small result set like a total or maximum. Stored procedures also provide consistent implementation of the business logic to clients written in different languages and running in different environments.

Some financial systems allow databases access through stored procedures alone, this restricts actions on the data to a small number of auditable queries.

Sybase SQL Server (Adaptive Server Enterprise) was the first commercially successful RDBMS to support stored procedures.

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found	The author also explains T-SQL essentials, stored procedures and functions, triggers, advanced T-SQL and the reporting services offered by SQL Server 2008. Beginning SQL Server 2008 for developers; from novice to professional by SciTech Book News so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. Microsoft Dynamics GP ? Renovated Microsoft Business Solutions Great ... by MusharfAnsari / Computers and Internet community 5, the platform supports the replication of non-data objects, which decreases the time and effort required to perform database administrative tasks, such as adding users or applying stored procedures to the target database, and the result is minimizing any downtime. GoldenGate version 9.5 by Database and Network Journal	storage system storage tank storage technologies storage time storage tube Storage Tube, Visual storage virtualization storage-retrieval machine storage-to-register instruction storage-to-storage instruction storage-type camera tube storage-type water heater StorageTek Storax store store and forward Store Bælt and Lille Bælt Store Bededag Store Belt store door handle store door latch store locator service store transmission bridge store-and-forward switch stored procedure Stored procedures stored program stored program concept stored response chain stored routine stored word stored-energy welding stored-program computer stored-program concept stored-program control stored-program logic stored-program numerical control stored-value card storefront storefront sash Storer, Francis Humphreys Storer, Maria Longworth Nichols storethrough storetrieval system storewidth storey Storey County storey rod Storey, David Storey, Moorfield Storfjord	Stored Basic Load Stored Chemical Energy Propulsion System Stored Command Processor Stored Command Sequence Stored Data Definition Language Stored Data Smooth Stored Data Warehouse Stored Emergency Power Supply System Stored energy Stored energy Stored energy Stored energy Stored Energy Rotary Drive Stored Forward Switching Stored Grain Research Laboratory Stored Heading Stored Human Red Blood Cells stored imagery repository and dissemination system Stored Information Retriever Stored Level Status Block Stored Logic 1 Stored Particle Atomic Physics Research Collaboration Stored procedure Stored procedure Stored Procedure Address Space Stored Procedure Class Wizard Stored Procedure Language Stored Procedure Object Interface Layer Stored procedures Stored program Stored program Stored program architecture Stored Program Command Stored Program Command Word stored program concept Stored Program Control Stored Program Control Switching System Stored Program Controlled Switching System Stored Program Element Stored Program Element System Stored Query Expression stored response chain stored routine Stored Serialization Graph Stored Upstream Address Stored Value Stored value card Stored value card Stored Value or Gift Card Stored Waste Examination Pilot Plant Stored Waste Retrieval Facility Stored Waveform Inverse Fourier Transform stored word Stored-Energy stored-energy foot

Mentioned in

References in periodicals archive

Encyclopedia browser

Full browser

No references found

The author also explains T-SQL essentials, stored procedures and functions, triggers, advanced T-SQL and the reporting services offered by SQL Server 2008.

Beginning SQL Server 2008 for developers; from novice to professional by SciTech Book News

so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.

Microsoft Dynamics GP ? Renovated Microsoft Business Solutions Great ... by MusharfAnsari / Computers and Internet community

5, the platform supports the replication of non-data objects, which decreases the time and effort required to perform database administrative tasks, such as adding users or applying stored procedures to the target database, and the result is minimizing any downtime.

GoldenGate version 9.5 by Database and Network Journal

storage virtualization

storage-retrieval machine

storage-to-register instruction

storage-to-storage instruction

storage-type camera tube