Question

sql 高手帮菜鸟看下，怎么错了?谢谢了

declare @ResumeState1 varchar(20)
select * from SearchView
where 1 = 1
and (case when @ResumeState1 = '未筛选' then
state = 0 //在这儿报错：= 附近有语法错误
else 1 = 1 end)

Answer 1

显示时推荐用case,条件推荐用改为 or

declare @ResumeState1 varchar(20)
select * from SearchView
where 1 = 1
and ((@ResumeState1 = '未筛选' and state = 0) or state=1)

Answer 2

declare @ResumeState1 varchar(20)
declare @sql varchar(100)
set @sql = 'select * from SearchView
where 1=1 and '+case when @ResumeState1='未筛选' then 'state = 0'
else '1 = 1'
end
exec(@sql)

Answer 3

then 后面只能跟值不能跟表达式 你这样写sql会理解判断state是否等于0 成为逻辑表达式所以不能那样写

declare @ResumeState1 varchar(20)
select * from SearchView
where state = (case when @ResumeState1 = '未筛选' then
0 else state end)

Answer 4

case 的语法不对 不能这样使用 state=(case when @ResumeState1 = '未筛选' then
state = 0 //在这儿报错：= 附近有语法错误
else 1 = 1 end)