.
, SQL-Server. SQL-Server; , .
, , ISQL. GO. , , .
, .
, . , , , . SQL-, . , , , .
SQL-Server 8 . , , , , , , 8 .
, , , : , .
, . , .
, , WHERE. , , .
, SQL-Server .
SQL-Server , : SHARED (), EXCLUSIVE (), UPDATE (). SHARED EXCLUSIVE :
, .
. , .
, , ROLLBACK . . , .
|
|
. . , BEGIN TRAN.
(SavePoint) - . , ROLLBACK . , :
SAVE TRANSACTION tran_name
ROLLBAC tran_name.
:
BEGIN TRAN
INSERT (, )
VALUES ('v',40)
COMMIT TRAN
: .