sql中的条件判断查询（SQL 多条件查询几种实现方法详细介绍）

if (@addDate is not null) and (@name <> '')
select * from table where addDate = @addDate and name = @name
else if (@addDate is not null) and (@name ='')
select * from table where addDate = @addDate 
else if(@addDate is null) and (@name <> '')
select * from table where and name = @name
else if(@addDate is null) and (@name = '')
select * from table 

select * from table where (addDate = @addDate or @addDate is null) and (name = @name or @name = '')