SQL where条件case when then

[jaccheng]

where( case when @time1<>@time2 then
(convert(char(10),so.PayDate,120) between @time1 and @time2)
case when @time1=@time2 then (convert(char(10),so.PayDate,120)=@time1))
求大神改改。如果@time1=@time2 条件就是 where convert(char(10),so.PayDate,120)=@time1
如果@time1<>@time2 条件就是 where convert(char(10),so.PayDate,120) between @time1 and @time2

[卖水果的net]

--你就用这一句就够了

where convert(char(10),so.PayDate,120) between @time1 and @time2

--当 @time1 = @time2 时，他与

 where convert(char(10),so.PayDate,120)=@time1

--等价

[还在加载中灬]

如上 另外，纠正下你的语法，CASE 要有END ，然后两个或级的判断，用OR隔开 最后，这种作日期范围条件限制，不建议在日期列上做变化， 可以改为where so.PayDate>= @time1 and so.PayDate<@time2，这样形式速度最快~