Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

Stored procedure

Index Stored procedure

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS). [1]

42 relations: Access control, Adaptive Server Enterprise, Business logic, C (programming language), C++, CUBRID, Cursor (databases), Data consistency, Data dictionary, Data integrity, Data validation, Database engine, Database trigger, Firebird (database server), IBM Db2, IBM Informix, Imperative programming, Java (programming language), Microsoft SQL Server, MySQL, NuoDB, Oracle Database, PL/pgSQL, PL/SQL, PostgreSQL, Prepared statement, Programming language, R (programming language), Relational database management system, Result set, SAP HANA, SQL, SQL PL, SQL/JRT, SQL/PSM, SQL:1999, SQL:2003, Subroutine, Transact-SQL, User-defined function, Virtuoso Universal Server, .NET Framework.

Access control

In the fields of physical security and information security, access control (AC) is the selective restriction of access to a place or other resource.

New!!: Stored procedure and Access control · See more »

Adaptive Server Enterprise

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.

New!!: Stored procedure and Adaptive Server Enterprise · See more »

Business logic

In computer software, business logic or domain logic is the part of the program that encodes the real-world business rules that determine how data can be created, stored, and changed.

New!!: Stored procedure and Business logic · See more »

C (programming language)

C (as in the letter ''c'') is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations.

New!!: Stored procedure and C (programming language) · See more »

C++

C++ ("see plus plus") is a general-purpose programming language.

New!!: Stored procedure and C++ · See more »

CUBRID

CUBRID ("cube-rid") is an open source SQL-based relational database management system (RDBMS) with object extensions developed by Naver Corporation for web applications.

New!!: Stored procedure and CUBRID · See more »

Cursor (databases)

In computer science, a database cursor is a control structure that enables traversal over the records in a database.

New!!: Stored procedure and Cursor (databases) · See more »

Data consistency

Data consistency refers to the usability of data.

New!!: Stored procedure and Data consistency · See more »

Data dictionary

A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format".

New!!: Stored procedure and Data dictionary · See more »

Data integrity

Data integrity is the maintenance of, and the assurance of the accuracy and consistency of, data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data.

New!!: Stored procedure and Data integrity · See more »

Data validation

In computer science, data validation is the process of ensuring data have undergone data cleansing to ensure they have data quality, that is, that they are both correct and useful.

New!!: Stored procedure and Data validation · See more »

Database engine

A database engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database.

New!!: Stored procedure and Database engine · See more »

Database trigger

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

New!!: Stored procedure and Database trigger · See more »

Firebird (database server)

Firebird is an open source SQL relational database management system that "runs on Linux, Microsoft Windows, and several Unix platforms".

New!!: Stored procedure and Firebird (database server) · See more »

IBM Db2

IBM Db2 contains database-server products developed by IBM.

New!!: Stored procedure and IBM Db2 · See more »

IBM Informix

IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings.

New!!: Stored procedure and IBM Informix · See more »

Imperative programming

In computer science, imperative programming is a programming paradigm that uses statements that change a program's state.

New!!: Stored procedure and Imperative programming · See more »

Java (programming language)

Java is a general-purpose computer-programming language that is concurrent, class-based, object-oriented, and specifically designed to have as few implementation dependencies as possible.

New!!: Stored procedure and Java (programming language) · See more »

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

New!!: Stored procedure and Microsoft SQL Server · See more »

MySQL

MySQL ("My S-Q-L") is an open-source relational database management system (RDBMS).

New!!: Stored procedure and MySQL · See more »

NuoDB

NuoDB is a database company based in Cambridge, Massachusetts.

New!!: Stored procedure and NuoDB · See more »

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

New!!: Stored procedure and Oracle Database · See more »

PL/pgSQL

PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS.

New!!: Stored procedure and PL/pgSQL · See more »

PL/SQL

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database.

New!!: Stored procedure and PL/SQL · See more »

PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

New!!: Stored procedure and PostgreSQL · See more »

Prepared statement

In database management systems (DBMS), a prepared statement or parameterized statement is a feature used to execute the same or similar database statements repeatedly with high efficiency.

New!!: Stored procedure and Prepared statement · See more »

Programming language

A programming language is a formal language that specifies a set of instructions that can be used to produce various kinds of output.

New!!: Stored procedure and Programming language · See more »

R (programming language)

R is a programming language and free software environment for statistical computing and graphics that is supported by the R Foundation for Statistical Computing.

New!!: Stored procedure and R (programming language) · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: Stored procedure and Relational database management system · See more »

Result set

A SQL result set is a set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column.

New!!: Stored procedure and Result set · See more »

SAP HANA

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.

New!!: Stored procedure and SAP HANA · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Stored procedure and SQL · See more »

SQL PL

SQL PL stands for Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB Version 7) database system.

New!!: Stored procedure and SQL PL · See more »

SQL/JRT

SQL/JRT, or SQL Routines and Types for the Java Programming Language, is an extension to the SQL standard first published as ISO/IEC 9075-13:2002 (part 13 of SQL:1999).

New!!: Stored procedure and SQL/JRT · See more »

SQL/PSM

SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

New!!: Stored procedure and SQL/PSM · See more »

SQL:1999

SQL:1999 (also called SQL 3) was the fourth revision of the SQL database query language.

New!!: Stored procedure and SQL:1999 · See more »

SQL:2003

SQL:2003 is the fourth revision of the SQL database query language.

New!!: Stored procedure and SQL:2003 · See more »

Subroutine

In computer programming, a subroutine is a sequence of program instructions that performs a specific task, packaged as a unit.

New!!: Stored procedure and Subroutine · See more »

Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.

New!!: Stored procedure and Transact-SQL · See more »

User-defined function

A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment.

New!!: Stored procedure and User-defined function · See more »

Virtuoso Universal Server

Virtuoso Universal Server is a middleware and database engine hybrid that combines the functionality of a traditional Relational database management system (RDBMS), Object-relational database (ORDBMS), virtual database, RDF, XML, free-text, web application server and file server functionality in a single system.

New!!: Stored procedure and Virtuoso Universal Server · See more »

.NET Framework

.NET Framework (pronounced dot net) is a software framework developed by Microsoft that runs primarily on Microsoft Windows.

New!!: Stored procedure and .NET Framework · See more »

Redirects here:

Sproc, Stored procedures, StoredProc, Storp.

References

[1] https://en.wikipedia.org/wiki/Stored_procedure

OutgoingIncoming
Hey! We are on Facebook now! »