Truco de SQL Server - Where condicional

AND 1 = CASE
WHEN @Variable > 0 THEN
CASE
WHEN IDTabla = @Variable THEN 1
ELSE 0
END
ELSE 1
END

Otra variante:

AND (@IdZona = 0 OR @IdZona = a.IDZona)