Please Help Me With SavePoint
Jan 15, 2008Hi,
I'm studying MS SQL 2000, and i see SAVE POINT statement. I try it:
===================================
BEGIN TRANSACTION
UPDATE emp SET sal = 2000 WHERE ename = 'BLAKE'
SAVE TRANSACTION SAVETRANS_1
UPDATE emp SET sal = 1500 WHERE ename = 'CLARK'
SAVE TRANSACTION SAVETRANS_2
SELECT SUM(sal) FROM emp
ROLLBACK TRANSACTION SAVETRANS_2
UPDATE emp SET sal = 1200 WHERE ename = 'CLARK'
COMMIT TRANSACTION
===================================
But it always rollback to SAVETRANS_1. I do not know how to ? Please help me. Thanks you very much.
Best gurad,
HaiNguyen - Sorimachi Viet Nam - lh9911051@yahoo.com