34,590
社区成员
发帖
与我相关
我的任务
分享
ISNULL(Result3,9) =CASE WHEN @result3='0' THEN 0
WHEN @result3='2' THEN 2
ELSE 9
END
(ISNULL(Result3,9) =CASE WHEN @result3='0' THEN 0 WHEN @result3='2' THEN 2 ELSE 9 END) or convert(int,@result3) =0
DECLARE @result3 INT
SET @result3 = ''
SELECT * FROM table_name
WHERE 1 = 1
AND (@result3 = '' OR
ISNULL(Result3,9) =CASE WHEN @result3='0' THEN 0
WHEN @result3='2' THEN 2
ELSE 9
END
)