学习SQL日记--case a when 1 then x when 2 then y else a end

declare @table table (a varchar(2),b varchar(2))
insert into @table
select 'cc','a1' union all
select 'cc','b2'

select a,case when a='cc' and b='a1' then 'b5' else b end as b from @table

/*
a    b
---- ----
cc   b5
cc   b2
*/

 

2011-05-05

http://topic.csdn.net/u/20110504/13/2cb2b395-4ea4-462a-a22f-d78c9251bd26.html