SELECT*FROM KC_GoodStandard WHERE ( CASE WHEN 'undefined'='{传入的参数}' THEN 1 ELSE 0 END )=1 OR GoodId='{传入的参数}' SELECT*FROM KC_GoodStandard WHERE ( CASE WHEN ''='{传入的参数}' THEN 1 ELSE 0 END )=1 OR GoodId='{传入的参数}'
SELECT*FROM KC_GoodStandard WHERE ( CASE WHEN 'undefined'='{传入的参数}' THEN 1 ELSE 0 END )=1 OR GoodId='{传入的参数}' SELECT*FROM KC_GoodStandard WHERE ( CASE WHEN ''='{传入的参数}' THEN 1 ELSE 0 END )=1 OR GoodId='{传入的参数}'
转载于:https://www.cnblogs.com/dyhao/p/10913018.html