sql query if parameter is null select all

Question

I've the following query:

SELECT NAME, SURNAME FROM MY_TABLE WHERE NAME = ?;

Now I want that if '?' is NULL, all records have to be selected. How can I achieve this in SQL? Thanks

Answer 1

Try this:

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