What are you struggling with? I'm not sure I understand.

If you're stuck implementing the parameters into your code, you use the parameter in place of a value.

E.g if we have a parameter called "pGender" to get either all males or all females (or all undefined) in our database:

SELECT p.Name,

p.DOB,

p.Address,

p.Gender

FROM dbo.MyPersonTable p

WHERE p.Gender = @pGender