4. SQL Server.
.
, , . . - : .
4 :
1. , . .
2. .
3. ( ).
4. - , .
. (CHECK), .
:
, . , .
(CHECK) , . , , . , : Price DiscountedPrice, , , Price >= DiscountedPrice. , TRUE FALSE .
.
Price NakladnayaDet 0 ( ). :
1. - 养.
2. :
3. Price > 0.
4. .
Price SQL Server , .
. , 4 . PasportSeria LIKE [0-9][0-9][0-9][0-9]. [0-9] 0 9.
.
1. , Kolvo 0.
|
|
2. Kolvo Price OrderDet CurrentPrice Tovar.
3. 6 .
4. Prodavec: (HireDate) (LeaveDate), NULL.
5. , ( ) 18 .
SQL Server 2005.
, , , , . , , , , . , , , .
(VIEWS).
, , . , , , . ( , , ), .
:
, . , Tovar GrupName.
1. - .
2. : Tovar Grup
3. : Tovar GrupName Grup. , . INNER JOIN ( ).
4. , vTovar.