create table t1
(
c1 int,
c2 int
)
begin transaction
insert t1 values(4,4)
update t1 set c1 = 'r'
commit
select * from t1
一定没有结果,这不就说明rollback了吗?
(
c1 int,
c2 int
)
begin transaction
insert t1 values(4,4)
update t1 set c1 = 'r'
commit
select * from t1
一定没有结果,这不就说明rollback了吗?
creat table aa (a int,b int)
goBegin tran
insert aa values(1,2)
insert aa values('w',2)
commit tran
go
select * from aa