BEGIN TRAN;
select * from tbl1;
DELETE FROM tbl1 where age=32 OR age=79;
select * from tbl1;
ROLLBACK TRAN;
select * from tbl1;
BEGIN TRAN;
select * from tbl1;
DELETE FROM tbl1 where age=32 OR age=79;
select * from tbl1;
COMMIT TRAN;
select * from tbl1;
No comments:
Post a Comment