select * into #1 from T1 update T1 set name=B.name from T1 A,#1 B where A.num=B.num and A.name<>B.name
select * into #t1 from t1 update t1 set name=(select name from #t where id=2 ) where id=1 update t1 set name=(select name from #t where id=1) where id=2
T1(id,name,num)
1,aa,5
2,bb,5
3,cc,10
要做到记录这间的数据交换,即如下效果:
T1(id,name,num)
1,bb,5
2.aa,5
c,cc,10
update T1 set name=B.name from T1 A,#1 B where A.num=B.num and A.name<>B.name
select * into #t1 from t1
update t1 set name=(select name from #t where id=2 )
where id=1
update t1 set name=(select name from #t where id=1)
where id=2