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.
ADVERTISER DISCLOSURE: SOME OF THE PRODUCTS THAT APPEAR ON THIS SITE ARE FROM COMPANIES FROM WHICH TECHNOLOGYADVICE RECEIVES COMPENSATION. THIS COMPENSATION MAY IMPACT HOW AND WHERE PRODUCTS APPEAR ON THIS SITE INCLUDING, FOR EXAMPLE, THE ORDER IN WHICH THEY APPEAR. TECHNOLOGYADVICE DOES NOT INCLUDE ALL COMPANIES OR ALL TYPES OF PRODUCTS AVAILABLE IN THE MARKETPLACE.