您好！请帮助一下：SQL2000符合条件更新到另字段

drop table #表1
create table #表1(BB varchar(4),CC varchar(4),DD varchar(4))
go
insert into #表1
select '102','442','102' union all
select '205','445','205' union all
select '306','446','306' union all
select '707','447','706' union all
select '405','445','405'

select * from #表1

update #表1 set dd=cc,cc='' where bb in('102','205','306','405')

select * from #表1