|
Category: ASE: T-SQL: DQL
Query
A query (lat.: "quaerere": to question, search) describes a
search request sent to a
database.
The most common database query language is
SQL.
(Structured Query Language).
In addition,
ASE
provides
T-SQL,
an extension to SQL.
Queries are generally only
DQL
and
DML.
A query consists of seperate elements. Simple queries search for
data on one
table
in a database, without further conditions.
More complex queries are , for example, formed of conditions and
joins
over several tables and might make use of
subqueries.
The most important and generally well known language elements of a
query are
select,
insert,
update
and
delete.
|
