Joe Celko's SQL for Smarties, 5th Edition

Chapter 15

Table Operations

Abstract

SQL is tiered and some operations work at that level.

Keywords

BEGIN ATOMIC

Bulk load

COMMIT

CURRENT OF < cursor name >

DELETE FROM statement

ELSE

INSERT INTO statement

MERGE statement

Redundant duplicates

ROLLBACK

ROWID

SET

THEN

UPDATE statement

USING

WHEN [NOT] MATCHED

WHERE

There are only four things you can do with a set of rows in an SQL table: insert them into a table, delete them from a table, update the values in their rows, or query them. The unit of work is a set of whole rows inside a base table.

When you worked with file systems, access was one record at a time, then one field within a record. As you had repeated groups and other forms of variant records, you could change the structure of ...