SQL Server
Allow to Pass Optional Parameters to a Stored Procedure
This article shows how to use string parameters to make selection on Boolean fields. What is it you need to select “true”, “false” of “ALL” records. How WHERE statement will look like in that case?