我想实现如下功能:
where
case when (@a = null)
then 1 = 1
else @a=a
and b=@b
但是这样报错,经过翻阅资料找到如下解决方案:
where
(1 = (CASE WHEN @a IS NULL THEN 1 ELSE 0 END)
OR a=@a )
AND b=@b