Stored Procedure

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.