create procedure getdataRaj
@en varchar(20),@s int
as
begin
select dbo.Emp100.Eno,ename,sal from Emp100
where ename =
CASE ename
WHEN @en THEN ename
end
or sal=
CASE sal
WHEN @s THEN Sal
end
end
select * from Emp100
exec getdataRaj Null,NULL
exec getdataRaj 'Jaggu',NULL
exec getdataRaj NULL,9000
exec getdataRaj 'SAI',NULL
@en varchar(20),@s int
as
begin
select dbo.Emp100.Eno,ename,sal from Emp100
where ename =
CASE ename
WHEN @en THEN ename
end
or sal=
CASE sal
WHEN @s THEN Sal
end
end
select * from Emp100
exec getdataRaj Null,NULL
exec getdataRaj 'Jaggu',NULL
exec getdataRaj NULL,9000
exec getdataRaj 'SAI',NULL