In database management systems (DBMSs)
, an operation that is stored with the database server
. Typically, stored procedures are written in SQL
. They’re especially important for client-server
database systems because storing the procedure on the server side means that it is available to all clients
. And when the procedure is modified, all clients automatically get the new version.