显示语法错误'关键字附近的语法错误'是'。' [英] Shows error in syntax 'Incorrect syntax near the keyword 'is'.'

问题描述

select uploadid,EntryMode
from uploads 
where
CASE
  WHEN @EntryMode='All' THEN EntryMode is not null
  WHEN @EntryMode='App' THEN EntryMode is null
  ELSE EntryMode =@EntryMode
END

推荐答案

尝试：

Try:

WHERE (@EntryMode='All' AND EntryMode is not null) OR
      (@EntryMode='App' AND EntryMode is null) OR
       @EntryMode = EntryMode

这篇关于显示语法错误'关键字附近的语法错误'是'。'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！