Select into temp table in new order, truncate original table, drop temp table.
select sno, c as a, a as b, b as c into #mytemptable from mytable
truncate table mytable
insert into mytable select * from #mytemptable
drop table #mytemptable
Hope this helps,
Fredrik