SQL 70- IBM . , SQL. SQL. 70- . 1992 . SQL92 SQL . SQL. SQL.
MS SQL , .
. Transact SQL :
, . @, # . , . , Transact SQL @@, ##. @@.
, , , . .
, , . Transact SQL .
, . .
128 . , 116 .
T-SQL. .
SQL , , , .
, . .
SQL :
1. - , .
2. , .
3. - . , .
4. - , .
|
|
5. - , .
, :
1. () .
2. . SQL- .
3. - , , . *, /, +, -, %.
4. - - (). +.
5. .
. : =, >, <, <=, >=,!= <>, !<, !>. , NULL.
6. .
TRUE FALSE , .
T-SQL :
ALL - .
AND - .
ANY, SOME - .
BETWEEN - , .
EXIST TRUE, .
IN - TRUE, .
LIKE - .
NOT - .
OR - TRUE, TRUE.