.


:




:

































 

 

 

 


T-SQL.




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.

 

 





:


: 2017-02-28; !; : 1269 |


:

:

: , , , , .
==> ...

777 - | 713 -


© 2015-2024 lektsii.org - -

: 0.007 .