Statements

an atomic unit of work and either completely succeeds or completely fails.

A SQL statement is a set of instruction that consists of identifiers, parameters, variables, names, data types, and SQL reserved words that compiles successfully.

Data Definition Language (DDL) Statements

• defines data structures.

Statements
ALTER
Collations
CREATE
DROP
DISABLE TRIGGER
ENABLE TRIGGER
RENAME
UPDATE STATISTICS
TRUNCATE TABLE

Data Manipulation Language (DML) Statements

• affect the information stored in the database.

Statements
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE

SET Statements

• determine how the current session handles run time settings.

Statement	Description
SET STATISTICS TIME { ON | OFF }	Displays the number of milliseconds required to parse, compile, and execute each statement.