这样......

 选择 * 来自 A 其中（1 = 1）和 Isemailsend72 = 案例 当  @ hour  =  72   then   0   else   1  结束 

快乐编码！

：）

select * from A where (1=1) and case @hour when   72 then Isemailsend72 = 0 else IsEmailsend72=1 end 

this give me error ''Incorrect syntax near ''=''.''


Thanks.

This way...

select * from A where (1=1) and Isemailsend72 = case when  @hour = 72 then 0 else 1 end

Happy Coding!
:)