Open main menu
Home
Random
Recent changes
Special pages
Community portal
Preferences
About Wikipedia
Disclaimers
Incubator escapee wiki
Search
User menu
Talk
Dark mode
Contributions
Create account
Log in
Editing
Relational database
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
===Stored procedures=== {{Main|Stored procedure}} A stored procedure is executable code that is associated with, and generally stored in, the database. Stored procedures usually collect and customize common operations, like inserting a [[tuple]] into a [[relation (database)|relation]], gathering statistical information about usage patterns, or encapsulating complex [[business logic]] and calculations. Frequently they are used as an [[application programming interface]] (API) for security or simplicity. Implementations of stored procedures on SQL RDBMS's often allow developers to take advantage of [[Procedural programming|procedural]] extensions (often vendor-specific) to the standard [[Declarative programming|declarative]] SQL syntax. Stored procedures are not part of the relational database model, but all commercial implementations include them.
Edit summary
(Briefly describe your changes)
By publishing changes, you agree to the
Terms of Use
, and you irrevocably agree to release your contribution under the
CC BY-SA 4.0 License
and the
GFDL
. You agree that a hyperlink or URL is sufficient attribution under the Creative Commons license.
Cancel
Editing help
(opens in new window)