思路错了
下拉设计
存储过程
set @where_jcstatues='1=1'
if(len(@jcstatus)==0) begin
set @where_jcstatues=@where_jcstatues
end
else begin
set @where_jcstatues=@where_jcstatues+' and ('+@jcstatus+')'