Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
3,896,355,413 visitors served.
forum Join the Word of the Day Mailing List For webmasters
?
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

stored procedure
(redirected from Sproc)

   Also found in: Wikipedia 0.01 sec.
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.


Want to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit the webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
Feedback
Mentioned in?  References in periodicals archive?   Encyclopedia browser?   Full browser?
No references found
 
Captain Tom Frazer and First Officer Rob Sproc, Chairman and Vice Chairman of the MIA pilot crew base, will also be on hand.
Captain Tom Frazer and First Officer Rob Sproc, Chairman and Vice Chairman of the MIA pilot crew base, will also be on hand.
In 1992, Electronic Design magazine cited the STAR SPROC processor as the DSP Innovation of the Year for its ability to perform concurrent parallel processing on multiple streams of data.
 
 
 
Encyclopedia
?

Terms of Use | Privacy policy | Feedback | Advertise with Us | Copyright © 2012 Farlex, Inc.
Disclaimer
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.