how is this technique all that clever? If anything, using

select *

from Customers

where customerid=isnull(@customerid,customerId)

is more efficient, easier to read and takes up less space.