把表A 的 ANAME 列 的值换为 BNAME 的值, 把BNAME的值换成ANAME值
select * into AA _Bak from A
update A set ANAME = BNAME
update A
set BNAME=AA.BNAME
from AA
where AA . ID=A . ID
and len(AA.BNAME) > 0
把表A 的 ANAME 列 的值换为 BNAME 的值, 把BNAME的值换成ANAME值
select * into AA _Bak from A
update A set ANAME = BNAME
update A
set BNAME=AA.BNAME
from AA
where AA . ID=A . ID
and len(AA.BNAME) > 0