纯SQL 语句 当WHERE后的查询条件为null或‘’，则不作为查询条件

上代码

DECLARE  @MEMBERCODEPARAM VARCHAR(50),
WITH CTE AS (
    SELECT
        A.BILLDATE
    FROM
        TABLE 1 A WITH (NOLOCK)
    JOIN
        TABLE  2 B WITH (NOLOCK) ON A.ID = B.ID
    JOIN
        TABLE 3  C WITH (NOLOCK) ON A.ID= C.ID
    WHERE
        A.字段 = '1212'
        AND A.日期字段 BETWEEN '2023-06-05' AND '2023-06-08' 
			  	AND (
            @memberCodeParam = '' --查询条件为空为跳过不作为查询条件
            OR A.MEMBERCODE = @memberCodeParam
        )
    GROUP BY
        A.BILLDATE
)
SELECT *
FROM CTE