sybase 的rollback
请问rollback之前必须先begin tran吗?如果没有begin tran,直接rollback,会怎样? 本帖最后由 2BeSybPro 于 2012-08-16 01:57 编辑是的,要用"begin tran",否则什么也不会发生。
1> select * from test
2> go
id name
----------- --------------------
(0 rows affected)
1> insert into test values(1,'Who Gentle')
2> go
(1 row affected)
1> rollback
2> go
1> select * from test
2> go
id name
----------- --------------------
1 Who Gentle
(1 row affected)
1> begin tran
2> go
1> insert into test values(2,'When Jobs')
2> go
(1 row affected)
1> rollback
2> go
1> select * from test
2> go
id name
----------- --------------------
1 Who Gentle
(1 row affected)
页:
[1]