SQL Server . , SQL API ( ). . , . , , , , .
SQL Server :
- ;
- ;
- .
: . . .
:
SET IMPLICIT_TRANSACTIONS OFF
() SQL Server , . :
SET IMPLICIT_TRANSACTIONS ON
, , :
: ;
BEGIN TRAN[SACTION]
[_ |
@__
[WITH MARK [_]]]
: , , , , ;
COMMIT [TRAN[SACTION]
[_ |
@__]]
: ;
SAVE TRAN[SACTION]
{__ |
@___}
: , , , . , BEGIN TRANSACTION , , , SAVE TRANSACTION.
ROLLBACK [TRAN[SACTION]
[_ |
@__
| __
|@___]]
@@TRANCOUNT .
@@NESTLEVEL .
, .
|
|
- . , . . () , , , . , ( ), ( ) , ACID , . , .
COMMIT TRANSACTION . COMMIT "" . COMMIT TRANSACTION , , .
ROLLBACK TRANSACTION , , () . ROLLBACK TRANSACTION . , . , . , SAVE TRANSACTION, .
:
BEGIN TRAN
SAVE TRANSACTION point1
point1
DELETE FROM WHERE =2
SAVE TRANSACTION point2
point2 2.
DELETE FROM WHERE =3
SAVE TRANSACTION point3
point3 2 3.
DELETE FROM WHERE <>1
ROLLBACK TRANSACTION point3
2 3, .
SELECT * FROM
SELECT 2 3.
ROLLBACK TRANSACTION point1
.
SELECT * FROM
COMMIT
.
, , ,
.
- , ( . 18 ).
- , .
|
|
- , ( ) , .
:
- .
- .
- .
- ( ): , ..
() , . , .
(- ) , , , , .
" " ( ), , .
, . . , ().
(, ), . , , , , , .. , . , , , . . , , , ..
. , (, : , , ..). , . , , , .. . : , , , .., .
. , , .
, . , . _ : _, _ _ ( , ).
. , , . , . , . .
|
|
(, ) , . , , . - (ER-).
() , . , , .. .
. , . - (ER - Entity-Relationship).
, :
- , ;
- ;
- ( );
- , , ;
- ;
- ; , ( ) , , ;
- , .
:
- , ER- ( "-");
- ;
- ;
- , ;
- .
ER-
ER- .
R- (entity type), . ( ) ( ) .
. .
:
- - , - ;
- - , - .
|
|
ER- , .
- .
. .
, . , . , , , . ER- , . ( ) . , , , . , , . , .
- , . , . , " " (Rooms) Property_for_Rent 1 15. . , (Address) ( Staff) ( Owner) . , .
, . .
, .
, , , ( ) .
. , , , . , .
, . .
- , . , .
, .
, . , , .
, .
, , , , .
. .
. , , .
, .
(binary).
(ternary).
(quaternary).
, .
- - . ( ).
|
|
, . , - .
, , . views Client Prop-erty_for_Rent. , , , .
, .
-. " " (1:1), " " (l:) " " (M:N).
-- , () (). -- , , .
-- , () (). . ( "") , ( "") - .
-- , , . -- , . -- .
, .
: (total) (partial). , , . . (mandatory), (optional).
, - .
EER-
R- R- / . / , , , .