sql语句怎么实现动态条件

Question

select * from T where operator = (case when @type = 0 then @o1 else is not null end)

 

主要是想根据@type 用不同的条件

当@type = 0 时 operator = @o 否则 operator is not null

 

请问各位大侠SQL语句怎么写，最好不要用字符串拼接

Answer 1

select *&nbsp;from T&nbsp;where (operator = @o1 and&nbsp;@type = 0 ) or (&nbsp;@type <> 0 and operator&nbsp;is not null )