SQLServer2008 在where条件中使用CASE WHEN
create table #temp( id int identity(1,1), name varchar(20), startYear int, startMonth int)insert into #tempselect 'z','2010','12' union allselect 'e','2011','11' union allselect 'a','201...