多字段查询优化 (like 放弃 or )
--方式1
AND CASE WHEN new_imei LIKE @imei THEN 1 WHEN new_enterimei LIKE @imei THEN 1 ELSE 0 END = 1
--方式2
AND CASE WHEN SUBSTRING(new_imei,0,LEN(@imei)+1) =@imei THEN 1 WHEN SUBSTRING(ISNULL(new_enterimei,''),0,LEN(@imei)+1) =@imei THEN 1 ELSE 0 END = 1

浙公网安备 33010602011771号