BEGIN...END
. Transact-SQL .
Transact-SQL , BEGIN...END . , , .
IF...ELSE
. :
IF Boolean_expression
{sql_statement | statement_block}
[ELSE
{sql_statement | statement_block}]
Boolean__expression .
CASE...END
IF...ELSE. CASE...END , . CASE...END :
CASE input_expression
WHEN { when_expression | Boolean_expression }
THEN result_expression
[...n]
[ ELSE else_result_expression ]
END
input_expression . when_expression input_expression. when_expression input_expression , CASE...END result_expression. WHEN...THEN, input_expression. WHEN...THEN, , ELSE.
. .
. :
1) ?
2) ?
3) , ?
4) ?
, , . (constraints). SQL Server :
1. (Primary Key);
2. (Foreign Key);
3. (Unique);
4. (Check);
5. (Defaults);
6. (NULL).
(Identity)
, . , , . SQL Server. Identity. .
, SQL Server , . uniqueidentifier.