现在我有一张表T1是这样的
A B
MS001 0
MS002 0
MG001 0
MG002 0
我现在UPDATE 字段B :字段A为MS开头的设为0.01,字段A为MG开头的设为0.02,理想结果为
A B
MS001 0.01
MS002 0.01
MG001 0.02
MG002 0.02
A B
MS001 0
MS002 0
MG001 0
MG002 0
我现在UPDATE 字段B :字段A为MS开头的设为0.01,字段A为MG开头的设为0.02,理想结果为
A B
MS001 0.01
MS002 0.01
MG001 0.02
MG002 0.02
UPDATE T1
SET B = CASE LEFT(A,2) WHEN 'MS' THEN 0.01 ELSE '0.02' END
SET B = CASE LEFT(A,2) WHEN 'MS' THEN 0.01 ELSE '0.02' END
where left(a,2)='ms'
declare @t1 table
( A varchar(8),
B decimal(5,2)
)insert into @t1 select 'MS001',0
union all select 'MS002',0
union all select 'MG001',0
union all select 'MG001',0update @t1 set B= case when A like'%MS%' then 0.01
when A like '%MG%' then 0.02
else 1 end
select * from @t1
update t1 set b=case when left(a,2)='MS' then o.o1 when left(a,2)='MG' then 0.02 end
WHEN 'MG'THEN 0.02
WHEN 'ML' THEN 0.03
WHEN THEN --还有其他条件就这样添加
END )
UPDATE T1 SET B = (CASE LEFT(A,2) WHEN 'MS' THEN 0.01
WHEN 'MG'THEN 0.02
WHEN 'ML' THEN 0.03
WHEN THEN
when then
else 0.10
END )
0.01 0.02种类多么?
(case
when left(A,2)='MS' then 0.01
when left(A,2)='MG' then 0.02
--这里可以添加其它的种类
end)
14楼发广告。