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