SQL SERVER 2005中的Case When用法 select ItemCode,(case when t0.ItemCode='BHPSBP0010' then 'BHPSBP00101' else 'Not Match' end) as Testing from oitm t0