create table T(a varchar(20), b varchar(20)) insert T select '1,2,3,4,5,6', '3,2,4,2,7,5'declare @temp varchar(20) update T set @temp=b, b=a, a=@tempselect * from T--result a b -------------------- -------------------- 3,2,4,2,7,5 1,2,3,4,5,6(1 row(s) affected)
create table T(a varchar(20), b varchar(20))
insert T select '1,2,3,4,5,6', '3,2,4,2,7,5'declare @temp varchar(20)
update T set
@temp=b,
b=a,
a=@tempselect * from T--result
a b
-------------------- --------------------
3,2,4,2,7,5 1,2,3,4,5,6(1 row(s) affected)