22,209
社区成员
发帖
与我相关
我的任务
分享
create table t_test(
id int identity(1,1) primary KEY,
data1 int,
Data2 int,
Data3 int,
Data4 int,
Data5 int
)
go
insert into t_test(data1,data2,data3,data4,data5)
values(0,0,0,0,0)
insert into t_test(data1,data2,data3,data4,data5)
values(0,0,0,0,0)
insert into t_test(data1,data2,data3,data4,data5)
values(0,0,0,0,0)
insert into t_test(data1,data2,data3,data4,data5)
values(0,0,0,0,0)
insert into t_test(data1,data2,data3,data4,data5)
values(0,0,0,0,0)
set xact_abort on
begin tran
update TestLink.Testdb.dbo.t_test
set data1=data1+1
update TestLink.Testdb.dbo.t_test
set data2=data2+1
update TestLink.Testdb.dbo.t_test
set data3=data3+1
update TestLink.Testdb.dbo.t_test
set data4=data4+1
update TestLink.Testdb.dbo.t_test
set data5=data5+1