code:
declare @fruit varchar(70) set @fruit='apple' select * supermarket fruittype=@fruit how can make if variable @fruit set 'all' cause select statement retrieve values in table?
if write query this:
select * supermarket fruittype=@fruit or @fruit = 'all' then, in case @fruit equal 'all', where clause evaluates true.