1.多条件查询
第一种方法:
SELECT * FROM table WHERE ISNULL(addDate, @addDate) = @addDate and ISNULL(name, "") = @name
第二种方法:
SELECT * FROM table where
addDate = CASE @addDate IS NULL THEN addDate ELSE @addDate END,
name = CASE @name WHEN '' THEN name ELSE @name END