I am trying to do a stored procedure where when a you have a value then it returns one record but if no value is inserted into the stored procedure, it returns all records. So here is my stored procedure:
SELECT continentId, continentName
continentName = @continentName
So how would I set it that if @continentName is null, it returns all records? Thanks!