D>select ... from ... @id=0 or id=@id
D>

WHERE 
    (CASE WHEN @Id <> 0 THEN pc.Id ELSE 1 END)=
    (CASE WHEN @Id <> 0 THEN @Id ELSE 1 END)