case lb when 1 then 2 when 2 then 3 when 3 then 1 end
关键不要忘了其他值不变,也就是else,否则的话,别的值都变为空了 UPDATE ZD_YF SET LB WHEN 1 THEN 2 WHEN 2 THEN 3 WHEN 3 THEN 1 ELSE LB END
UPDATE ZD_YF SET LB = case LB when 1 then 2 when 2 then 3 when 3 then 1 else LB end
update ZD_YF set LB= case lb when 1 then 2 when 2 then 3 when 3 then 1 end
update ZD_YF set LB= case lb when 1 then 2 when 2 then 3 when 3 then 1 else lb end
update ZD_YF set LB=case LB when 1 then 2 when 2 then 3 when 3 then 1 else LB end SQL Server2000下测试通过
--测试下 create table test(iceno int ,goods varchar(10),[date] datetime,num int)insert test select 1000,'xx','2006-11-9',1 union allselect 1000,'yy','2006-11-9',1 union all select 1000,'zz','2006-11-9',2 union all select 1000,'xx','2006-11-9',1 union all select 1001,'hh','2006-11-9',2 select * from test select goods= case goods when 'xx' then '1' when 'yy' then '2' else goods end from test
UPDATE ZD_YF SET LB WHEN 1 THEN 2 WHEN 2 THEN 3 WHEN 3 THEN 1 ELSE LB END
case LB
when 1 then 2
when 2 then 3
when 3 then 1
else LB
end
create table test(iceno int ,goods varchar(10),[date] datetime,num int)insert test
select 1000,'xx','2006-11-9',1 union allselect 1000,'yy','2006-11-9',1 union all
select 1000,'zz','2006-11-9',2 union all
select 1000,'xx','2006-11-9',1 union all
select 1001,'hh','2006-11-9',2
select * from test
select goods= case goods when 'xx' then '1' when 'yy' then '2' else goods end from test