Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Stored Procedure

  • Tore Risch
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1120

Abstract

Modern relational query languages such as SQL provide general programming language capabilities in addition to the statements for searching and updating the database. A stored procedure is a user program written in a query language running inside the database server. Stored procedures often include side effects that update the database. This makes it possible to define general programs using the query language. These programs are called stored procedures and are executed inside the database server.

This is a preview of subscription content, log in to check access.

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Information TechnologyUppsala UniversityUppsalaSweden

Section editors and affiliations

  • Tore Risch
    • 1
  1. 1.Dept. of Inf. TechnologyUppsala Univ.UppsalaSweden