I am trying to create a sql server query select. I have one argument that can be null or not. WHen the @value is null I would like to return all mycolumns with the null value. If value is not null I want to return mycolumns with that value.
How best to handle this, i tried:
SELECT name FROM mytable
WHERE coalesce( @value,mycolumn)=mycolumn
I got a feeling it lies in the handling of the null value. How can I resolve?
where myColumn = @value or
(myColumn is null and @value is null)
SELECT T.name
FROM dbo.mytable T
WHERE
EXISTS (
SELECT @value INTERSECT SELECT T.mycolumn
)
;
1st case. when u pass a city name..
DECLARE @SearchType varchar(80);
SET @SearchType = 'Alamo';
Select * From Homes
where City = @SearchType OR Coalesce(@SearchType,'') = ''
2nd case. City null or empty.
SET @SearchType = '';
in first case you will get the result by city name. and in 2nd case you will get all the results.
Try:
SELECT name FROM mytable where myColumn = @value or @value is null
