34,838
社区成员




begin tran
update ....
select.....
commit tran
这样格式就OK了.好像也没遇到并发吗?是应为我数据量小海是怎么回事呢?begin tran
select.....
update ....
commit tran
create table tb(id int)
insert tb select id = 0
go
begin tran
declare @i int
select @i = max(id)+1 from tb
waitfor delay '00:00:30'
update tb set id = @i
commit tran
select * from tb
begin tran
declare @i int
select @i = max(id)+1 from tb
update tb set id = @i
commit tran
select * from tb