- 论坛徽章:
- 0
|
本帖最后由 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)
|
|