34,838
社区成员




create table test(a int, b int);
insert into test values(11,22),(33,44),(55,66),(77,88)
go
select * from test
go
update test set a = b, b=a where a > 20
go
select * from test
go
drop table test
go
(4 行受影响)
a b
----------- -----------
11 22
33 44
55 66
77 88
(4 行受影响)
(3 行受影响)
a b
----------- -----------
11 22
44 33
66 55
88 77
(4 行受影响)
完成时间: 2019-08-30T18:43:41.8078781+08:00