-
Операторы
-
Select
- DISTINCT, ALL
- TOP
-
WHERE
- Сравнение
- Логические
- BETWEEN
-
LIKE
- %
- [] [a-b]
- ^
- IN
- ALL, ANY, SOME
- EXISTS
-
GROUP BY
- Выборка или Агрегацая
-
HAVING
- HAVING COUNT(*) > 3
- ORDER BY
- OPTION
-
Insert
- Пакеты
-
SELECT RESULTS
- OTHER TABLE
- OTHER DATABASE
- Update
- Delete
- Create
-
Соединения
- Inner
- Left
- Right
- Full
- cross
-
Функции
-
Агрегаты
- MAX, MIN
- SUM
- AVG
- COUNT
-
CREATE
- TABLE
- ИМЕНА
-
DATA BASE
-
FILE
- ON
- FILEGROWTH
- MAXSIZE
- NAME
- FILENAME
- SIZE
- LOG FILE
- COLLATE
- FOR ATTACH