7
Answers

Sql server case statement in where clause

select * from table1 t1 where t1.active=1 and case when @x=1 then t1.name="" else t1.name<>"". please help to write it correct syntax 

Answers (7)