SQL:2003

SQLSQL standard2003 version of SQLSQL Standard 2003SQL:2003-14
SQL:2003 is the fourth revision of the SQL database query language.wikipedia
43 Related Articles

SQL

Structured Query LanguageSQL databaseSQL Databases
SQL:2003 is the fourth revision of the SQL database query language.

SQL:1999

ANSI SQL 99ANSI-99SQL 3
It introduced many new features, many of which required clarifications in the subsequent SQL:2003.

Merge (SQL)

MERGEupsertSQL Merge
It was officially introduced in the SQL:2003 standard, and expanded in the SQL:2008 standard.

Data definition language

DDLdata definitionCREATE
These information tables were specified as SQL/Schemata in SQL:2003.

Database

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

Query language

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

SQL:2008

:2008ANSI SQL:2008 standardISO/IEC 9075-11:2008
Which was updated by SQL:2008

XML

Extensible Markup LanguageXML documentXML parser

PDF

Portable Document FormatPDF format.pdf
The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.

Linter SQL RDBMS

LinterLinter SQL Server
Linter is a Russian DBMS compliant with the SQL:2003 standard and supporting the majority of operating systems, among them Windows, various versions of Unix, QNX, and others.

Cursor (databases)

Cursorcursorsdatabase cursor
This section introduces the ways the SQL:2003 standard defines how to use cursors in applications in embedded SQL.

SQL-92

SQL92SQL 92ANSI-92
Later revisions of the standard include SQL:1999 (SQL3), SQL:2003, SQL:2008, SQL:2011 and SQL:2016.

MonetDB

MonetDB/GISSciQLMonetDB.R
These included a new SQL frontend, supporting the SQL:2003 standard.

Transbase

Transaction Software GmbH
Transbase largely conforms with the SQL standard „SQL2 intermediate level“ (SQL-92) and supports various features of SQL2 follow-on versions (SQL:1999, SQL:2003 etc.).

Exasol

EXASolutionEXASOL AG
Exasol supports the SQL Standard 2003 and can be integrated via standard interfaces like ODBC, JDBC or ADO.NET.

Select (SQL)

SELECTSQL query keyword
A window function in SQL:2003 is an aggregate function applied to a partition of the result set.

Stored procedure

stored proceduresproceduresdatabase procedures
The increasing adoption of stored procedures led to the introduction of procedural elements to the SQL language in the SQL:1999 and SQL:2003 standards in the part SQL/PSM.

User-defined function

UDFUDFsuser defined
The SQL standard distinguishes between scalar and table functions.

Database trigger

triggerstriggerprocedural triggers
Triggers in Sedna were designed to be analogous to SQL:2003 triggers, but natively base on XML query and update languages (XPath, XQuery and XML update language).

View (SQL)

viewviewsdatabase view
Therefore, an ORDER BY clause in the view definition is meaningless; the SQL standard (SQL:2003) does not allow an ORDER BY clause in the subquery of a CREATE VIEW command, just as it is refused in a CREATE TABLE statement.

Where (SQL)

WHERELIKEWHERE clause
is an SQL reserved word.