create table T(ID int ,ID2 int)
insert T select 1,2update T
set ID=ID2,ID2=ID--这样select * from T
ID ID2
----------- -----------
2 1(所影响的行数为 1 行)
insert T select 1,2update T
set ID=ID2,ID2=ID--这样select * from T
ID ID2
----------- -----------
2 1(所影响的行数为 1 行)
insert @a
select '2007-1-2','2007-1-5'
union all
select '2007-1-5','2007-1-6'
update @a set name1=name2,name2=name1
select * from @a
/*(所影响的行数为 2 行)
(所影响的行数为 2 行)name1 name2
------------------------------------------------------ ------------------------------------------------------
2007-01-05 00:00:00.000 2007-01-02 00:00:00.000
2007-01-06 00:00:00.000 2007-01-05 00:00:00.000(所影响的行数为 2 行)
*/