sql query if parameter is null select all

March 28, 2023 by Tarik

Try this:

SELECT * 
FROM MY_TABLE 
WHERE @parameter IS NULL OR NAME = @parameter;