You can send a null (as the default value) and have it be an indicator that you don't need to filter by that parameter. For example:
select id, name
where (id = @parameter1 OR @parameter1 IS NULL)
and (name = @parameret2 OR @parameret2 IS NULL);Are you using an adhoc query or using a stored proc? If you are using a stored proc, there may be performance implications in this type of "catch-all" queries.