Databases Reference
In-Depth Information
SUMMARY
This chapter introduced the SQL language. We began with a general introduc-
tion to the SQL language and a comparison between interactive and embedded
SQL. We spent some time working with the most basic version of the SELECT
statement to retrieve values from a single table and to evaluate expressions. The
chapter also introduced the concept of operators and SQL language functions.
We also looked at function categories used in vendor implementations of SQL
and took a relatively close look at the SQL Server aggregate functions. We ended
with a discussion of DDL and DML statements, including the standard SQL syn-
tax for selected commands.
KEY TERMS
Access path
Aggregate function
Batch
Binary Operator
Built-in functions
Clause
Command operators
Command syntax
Data definition language (DDL)
Data manipulation language (DML)
Data query language (DQL)
Declarative statement
Default database
Deterministic function
Domain
Dynamic SQL
Embedded SQL
Explicit conversion
Function
Implicit conversion
Interactive SQL
Keyword
Minimally logged operation
Non-logged operation
Nondeterministic function
Operator precedence
Parameters
Parsing
Procedure
Qualifying conditions
Query mode
Relational result
Result set
Script
Search argument
Sqlcmd
Subquery
Temporary table
Transaction control
User-defined data type
Unary operator
Working database
